declaring variable ?

From: Lothar Behrens <lothar(dot)behrens(at)lollisoft(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: declaring variable ?
Date: 2007-07-01 12:03:14
Message-ID: 4802078e6d43acd33ae04dc0f8a652b3@lollisoft.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Browse pgsql-odbc by date

  From Date Subject
Next Message Nardmann, Heiko 2007-07-05 09:54:37 ChangeLog?
Previous Message Mark Cave-Ayland 2007-06-29 13:42:48 Re: Proposal for new pgsqlODBC feature - hiding tables inaccessible to the current user