PostgreSQL Features to Try

Re:PostgreSQL Features to Try by rezoner on Saturday April 27, 2019 @05:03PM (#19767617)

How about UPDATE LIMIT 1 instead of fancy edge case features?

[ Parent | on HN ]

Re:PostgreSQL Features to Try by other_herbert on Saturday April 27, 2019 @05:05PM (#19767627)

I'm curious why you need this? As a safety mechanism?

You could just do a select with the limit then update that row from the primary key...

[ Parent | on HN ]

Re:PostgreSQL Features to Try by lucb1e on Sunday April 28, 2019 @06:58PM (#19774326)

Sure, with a Turing compete system everything is a "you could just". It seems a lot easier to update limit 1 than to involve a subquery. If that is what GP meant it for, of course.

[ Parent | on HN ]

Re:PostgreSQL Features to Try by ratiolat on Saturday April 27, 2019 @05:05PM (#19767629)

UPDATE LIMIT 1 is an edge case

[ Parent | on HN ]