Re: [GENERAL] defining a variable

2008-06-12 Thread Raymond O'Donnell
On 12/06/2008 14:37, [EMAIL PROTECTED] wrote: I need to create a sql script and launch it from pgadmin. In this script some sql statements (INSERT) have to depend from the result of previous statements (SELECT). Is there a way to define a variable in SQL and set its value with the result of a SE

[GENERAL] defining a variable

2008-06-12 Thread luca . ciciriello
Hi All. I need to create a sql script and launch it from pgadmin. In this script some sql statements (INSERT) have to depend from the result of previous statements (SELECT). Is there a way to define a variable in SQL and set its value with the result of a SELECT query? Using the psql console I'v