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