"D. Dante Lorenso" wrote:
>Using a brain-dead sample table that looks like this:
>
> CREATE table some_table (
> col0 SERIAL,
> col1 VARCHAR,
> col2 VARCHAR
> );
>
>I want to do something like this:
>
> INSERT INTO some_table (col1, col2)
> VALUES ('val1', 'val2');
>
>I want the value of col0 returned to the application and I don't want to
>know the name of the sequence involved in the SERIAL column. I just
>want the value inserted into the column by using just it's column name.
Using 8.2 or above:
INSERT INTO some_table (col1, col2) VALUES ('val1', 'val2') RETURNING col0;
Rainer