PostgreSQL:update column with dates and return values

Question

I have a table:

For example current date 04/02/2020

  id   |   last_update   | update_frequency(days)
--------------------------------------------------
   1    |   01/02/2020   |   2
   2    |   01/02/2020   |   1
   3    |   01/02/2020   |   5

I would like to make a single query that will return ids to update.

   id   |
---------
    1
    2

So you want to update or select ids to update? There is a mismatch between title and the question itself. — Andronicus
– Andronicus, Commented Feb 15, 2020 at 10:43
@Ruslan . . . Please explain the rules for returning the rows you want. — Gordon Linoff
– Gordon Linoff, Commented Feb 15, 2020 at 12:49

Andronicus · Accepted Answer · 2020-02-15 10:45:22Z

1

You can use the following:

select id
from table_name
where extract('day' from (last_update - current_date)) >= update_frequency

answered Feb 15, 2020 at 10:45

Andronicus

26.2k18 gold badges55 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL:update column with dates and return values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related