Re: table synonyms - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: table synonyms
Date
Msg-id 1116956885.6139.24.camel@Andrea.peacock.de
Whole thread Raw
In response to Re: table synonyms  (<jjeffman@cpovo.net>)
Responses Re: table synonyms
List pgsql-general
Am Dienstag, den 24.05.2005, 13:49 -0300 schrieb jjeffman@cpovo.net:
> It will be a very pleasant idea. Although I am
> an application developer I don't know if I have
> enough knowledge to do that. Do you know how could
> I help the PostgreSQL development ?
>
> Another feature I missed is the "returning" clause
> of the Oracle "INSERT" SQL command, which allow the
> user to retrieve the "serial" value after an insert
> command, which works even in a concurrent network
> environment.

INSERT INTO table (...) values (...);
SELECT currval('table_id_seq');

See documentation for sequences.



pgsql-general by date:

Previous
From: Himanshu Baweja
Date:
Subject: getting lock information
Next
From: Devrim GUNDUZ
Date:
Subject: Re: Postgres 8.0.3 Fedora RPMS ?