feature request

From: sad <sad(at)bankir(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: feature request
Date: 2003-08-11 05:32:15
Message-ID: 200308110932.15448.sad@bankir.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
wanted.
i found "RETURNING" usable if it returns just inserted or just deleted record.
e.g. i have some DEFAULTS in field declarations and want to see what values
actually sot by the last insert.
now i forced to call SELECT after insert.

Browse pgsql-bugs by date

  From Date Subject
Next Message Nils Philippsen 2003-08-11 06:37:37 Correct Unicode sorting depends on how initdb was run
Previous Message Bruce Momjian 2003-08-11 03:02:48 Re: ALTER TABLE table RENAME TO sould change also sequence name