Re: plpgsql and insert

From: "Ben Trewern" <ben(dot)trewern(at)mowlem(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql and insert
Date: 2007-03-05 11:47:12
Message-ID: esh003$id0$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)doitonce(dot)net(dot)au> wrote in message
news:45EB4F76(dot)6000702(at)doitonce(dot)net(dot)au(dot)(dot)(dot)
> 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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-03-05 12:16:11 Re: date format
Previous Message Peter Eisentraut 2007-03-05 10:04:58 Re: date format