Re: table synonyms

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: jjeffman(at)cpovo(dot)net
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: table synonyms
Date: 2005-05-24 17:48:05
Message-ID: 1116956885.6139.24.camel@Andrea.peacock.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Dienstag, den 24.05.2005, 13:49 -0300 schrieb jjeffman(at)cpovo(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2005-05-24 18:33:29 Re: Problem merging two rows into same primary key
Previous Message Himanshu Baweja 2005-05-24 17:19:53 getting lock information