declaring variable ?

Hi,

I am searching for a way to do the following (MS SQL) in PostgreSQL:

declare @key as int

set @key = (select ID from table1 where name = '...')

insert into table2 (foreignkey, foreignvalue) values(@key, 'some value
here')

I didn't find such a syntax in the documentation.

Regards, Lothar

--
Lothar Behrens | Rapid Prototyping ...
Heinrich-Scheufelen-Platz 2 |
73252 Lenningen | www.lollisoft.de


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend