Skip site navigation (1) Skip section navigation (2)

Re: postgresql experts please help

From: Michael Schmidt <MichaelMSchmidt(at)msn(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: postgresql experts please help
Date: 2007-10-18 22:11:59
Message-ID: BAYC1-PASMTP122CBC3972F1908338F9D5A39E0@CEZ.ICE (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
There is:

SELECT currval(pg_get_serial_sequence('mytab','mycol'));

Tried this as an isolated statement and it returned null, so it appears 
to also require that nextval be run before it can work.

Michael Schmidt


pgsql-jdbc by date

Next:From: Kris JurkaDate: 2007-10-18 22:19:43
Subject: Re: postgresql experts please help
Previous:From: Andrei IlitchevDate: 2007-10-18 21:01:12
Subject: Re: Fw: postgresql experts please help

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group