Re: BUG #4656: Indexes not used when comparing nextval() and currval() to integers - Mailing list pgsql-bugs

toruvinn wrote:
> On Mon, 16 Feb 2009 10:37:27 +0100, Heikki Linnakangas
> <heikki.linnakangas@enterprisedb.com> wrote:
>> You can read the value returned by currval into a host language
>> variable and send it back as a ?.
> Wouldn't it be possible to do UPDATE booking_entries SET date = ? where
> id = (SELECT currval('booking_entries_id_seq'::regclass)); too?

Oh yes, that should work as well.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com