Received: from ns.itd.sterling.com (ns.itd.sterling.com [192.124.9.5]) by hub.org (8.9.3/8.9.3) with SMTP id QAA40631 for ; Tue, 1 Jun 1999 16:18:32 -0400 (EDT) (envelope-from keala_jacobs@itd.sterling.com) Received: ns.itd.sterling.com id AA10514; Tue, 1 Jun 1999 15:12:06 -0500 Message-Id: <37543F0D.2CD0E09D@itd.sterling.com> Date: Tue, 01 Jun 1999 15:14:05 -0500 From: Keala Jacobs Organization: Sterling Software X-Mailer: Mozilla 4.5 [en] (WinNT; I) X-Accept-Language: en Mime-Version: 1.0 To: pgsql-hackers@hub.org Subject: variables in psql Content-Type: multipart/mixed; boundary="------------96F7D7AEAA55A7AB52022F0E" This is a multi-part message in MIME format. --------------96F7D7AEAA55A7AB52022F0E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Does postgres support the use of variables as in the example below? update table1 set column1=@variable where column2='text4column2' and @variable=(select column3 from table2 where column4='text4column4'); If not, how do I execute a statement like this in postgres? --------------96F7D7AEAA55A7AB52022F0E Content-Type: text/x-vcard; charset=us-ascii; name="keala_jacobs.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Keala Jacobs Content-Disposition: attachment; filename="keala_jacobs.vcf" begin:vcard n:Jacobs;Keala tel;fax:(402) 292-6412 tel;home:(402) 291-6444 tel;work:(402) 232-7880 x-mozilla-html:FALSE org:Sterling Software;Information Technology Division adr:;;1404 Fort Crook Road South;Bellevue;NE;68005-2969;USA version:2.1 email;internet:keala_jacobs@itd.sterling.com title:Software Engineer fn:Keala Jacobs end:vcard --------------96F7D7AEAA55A7AB52022F0E--