Postgres Pro
Downloads
Home   >   mailing lists

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

From toruvinn
Subject Re: BUG #4656: Indexes not used when comparing nextval() and currval() to integers
Date
Msg-id op.upfv4euu33x80h@insanity.lain.pl
Whole thread Raw
In response to Re: BUG #4656: Indexes not used when comparing nextval() and currval() to integers  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-bugs
Tree view 
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? 

--
ru

pgsql-bugs by date:

Previous
From: "Tomasz Kolaj"
Date:
Subject: BUG #4659: Can't configure static postgresql with static openssl
Next
From: "ITAGAKI Takahiro"
Date:
Subject: BUG #4660: float functions return -0