feature request

Started by sadover 22 years ago1 messagesbugs
Jump to latest
#1sad
sad@bankir.ru

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.