Hi,
Sample table:
create table basket (
id serial NOT NULL PRIMARY KEY,
timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
);
How can I make a one step insert into the table and get values of 'ID' ?
I am trying to find a similar solution as in the oracle's INSERT ...
RETURNING.
If I use at first the INSERT, and after SELECT MAX(ID), the result will be
uncertain.
my system version: 7.0.2
Thx,
Andras s-andras(at)freemail(dot)hu