feature request - Mailing list pgsql-bugs

From sad
Subject feature request
Date
Msg-id 200308110932.15448.sad@bankir.ru
Whole thread Raw
List pgsql-bugs
hi all

it would be good to have RETURNING clause in INSERT,UPDATE,DELETE queries.
similar to Oracle's one but more clever.
Oracle's "RETURNING" is just a disguised independant SELECT wich is not=20
wanted.
i found "RETURNING" usable if it returns just inserted or just deleted reco=
rd.
e.g. i have some DEFAULTS in field declarations and want to see what values=
=20
actually sot by the last insert.
now i forced to call SELECT after insert.

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ALTER TABLE table RENAME TO sould change also sequence name
Next
From: Nils Philippsen
Date:
Subject: Correct Unicode sorting depends on how initdb was run