update latest db row with postgres sql

Question

I want to use postgres sql to update the latest row in the DB.

Here is how I get the latest row:

SELECT id, state_json, update_timestamp FROM ui_rules ORDER BY update_timestamp DESC LIMIT 1

How can I update and override that single row?

UPDATE ui_rules SET state_json = '{..}' WHERE ?;

Gordon Linoff · Accepted Answer · 2017-03-13 16:24:19Z

2

Assuming id is unique, you can add a where condition or join:

UPDATE ui_rules
    SET state_json = '{..}'
    WHERE id = (SELECT id
                FROM ui_rules
                ORDER BY update_timestamp DESC
                LIMIT 1
               );

answered Mar 13, 2017 at 16:24

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

update latest db row with postgres sql

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