Thread: 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
>