Re: Using oid as pkey

"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