Re: [GENERAL] plpgsql and insert

2007-03-05 Thread Ben Trewern 
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" <[EMAIL PROTECTED]> wrote in message 
news:[EMAIL PROTECTED]
> 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
> 



---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] plpgsql and insert

2007-03-04 Thread Andrej Ricnik-Bay 

Please say that again in English?

On 3/5/07, Jamie Deppeler <[EMAIL PROTECTED]> 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

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[GENERAL] plpgsql and insert

2007-03-04 Thread Jamie Deppeler 

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