When you do a SERIAL, it actually creates a Sequence which you can then
get the current value using: select currval('sequence name');
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: Phillip Rhodes [mailto:rhodespc@bellatlantic.net]
Sent: Wednesday, January 05, 2000 3:40 PM
To: 'pgsql-interfaces@postgreSQL.org'
Subject: [INTERFACES] jdbc question
All,
I have a table with a column type of serial.
If I do an insert into this table, is there a way to find out this
column's value?
Thanks!
PHillip
************