Обсуждение: plpgsql and insert
Hi, Have a quick question is possible to record a primary from a insert stament eg xprimary := insert into schema.table(.,.,.,.) VALUES (,,,,);
Please say that again in English? On 3/5/07, Jamie Deppeler <jamie@doitonce.net.au> wrote: > Hi, > > Have a quick question is possible to record a primary from a insert stament > > eg > > xprimary := insert into schema.table(.,.,.,.) VALUES (,,,,); > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm
Depending on what client side library you are using you could use the RETURNING clause, see the docs: http://www.postgresql.org/docs/8.2/static/sql-insert.html Regards, Ben "Jamie Deppeler" <jamie@doitonce.net.au> wrote in message news:45EB4F76.6000702@doitonce.net.au... > Hi, > > Have a quick question is possible to record a primary from a insert > stament > > eg > > xprimary := insert into schema.table(.,.,.,.) VALUES (,,,,); > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >