From: Keala Jacobs <keala_jacobs@itd.sterling.com>
To: pgsql-hackers@hub.org
Subject: variables in psql
Date: Tue, 01 Jun 1999 15:14:05 -0500
Message-ID: <37543F0D.2CD0E09D@itd.sterling.com> (raw)
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?
Attachments:keala_jacobs.vcf (text/x-vcard, 340B) download
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: keala_jacobs@itd.sterling.com, pgsql-hackers@hub.org
Subject: Re: variables in psql
In-Reply-To: <37543F0D.2CD0E09D@itd.sterling.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox