Re: [BUGS] BUG #6572: The example of SPI_execute is bogus - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [BUGS] BUG #6572: The example of SPI_execute is bogus
Date
Msg-id CAFj8pRD3WUDKC-q-EhCnraNXF9pyD9qSxGKQ0O=UkoHiisXAVQ@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #6572: The example of SPI_execute is bogus  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [BUGS] BUG #6572: The example of SPI_execute is bogus  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
>
> Yeah.  I think it would be a good idea for UPDATE and DELETE to expose
> a LIMIT option, but I can't really see the virtue in making that
> functionality available only through SPI.
>

I don't agree - LIMIT after UPDATE or DELETE has no sense. Clean
solution should be based on using updateable CTE.

Regards

Pavel


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Patch: add timing of buffer I/O requests
Next
From: Peter Geoghegan
Date:
Subject: Re: Patch: add timing of buffer I/O requests