| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | jjeffman(at)cpovo(dot)net |
| Cc: | Tino Wildenhain <tino(at)wildenhain(dot)de>, Postgresql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: table synonyms |
| Date: | 2005-05-24 17:10:37 |
| Message-ID: | 20050524171037.GA8129@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, May 24, 2005 at 13:49:40 -0300,
jjeffman(at)cpovo(dot)net wrote:
>
> 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.
While it might be nice to have a returning clause (and there has been
discussion of that in the past), you can do what want.
The currval function returns the last value assigned by nextval in
the current session and is safe from conflicts with concurrent operations.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2005-05-24 17:11:51 | Re: Update on tables when the row doesn't change |
| Previous Message | jjeffman | 2005-05-24 16:49:40 | Re: table synonyms |