Postgres Pro
Downloads
Home   >   mailing lists

Re: Implementation of LIMIT on DELETE and UPDATE statements (rel to 7.2.1) - Mailing list pgsql-patches

From Tom Lane
Subject Re: Implementation of LIMIT on DELETE and UPDATE statements (rel to 7.2.1)
Date
Msg-id 21423.1032791820@sss.pgh.pa.us
Whole thread Raw
In response to Re: Implementation of LIMIT on DELETE and UPDATE statements (rel to 7.2.1)  (srb@cuci.nl (Stephen R. van den Berg))
List pgsql-patches
Tree view 
srb@cuci.nl (Stephen R. van den Berg) writes:
> Anyway, since ctid's solve my problem, I'm not particularly keen on
> getting the LIMIT support on UPDATE/DELETE anymore.
> I still think that the ctid solution is ugly and non-portable.

Well, they're both ugly and nonportable, IMHO.

To me the deciding argument is that the LIMIT approach is also
dangerous, because it encourages people to use incompletely-specified
queries to modify their data.  See other messages in this thread for
examples.

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Implementation of LIMIT on DELETE and UPDATE statements
Next
From: Stephan Szabo
Date:
Subject: Re: Implementation of LIMIT on DELETE and UPDATE statements