currval/sequence

From: "cristi" <cristi(at)dmhi(dot)ct(dot)ro>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: currval/sequence
Date: 2003-08-15 09:22:50
Message-ID: 005101c3630e$cd28c900$7201a8c0@dmhi.ct.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

What is wrong here?

insert into table_name (field_name) values (select
setval('sequence_name')-1) as currval);

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Aled Morris 2003-08-15 12:38:31 using procedural languages...
Previous Message Stephan Szabo 2003-08-15 04:45:58 Re: COLLATE