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?

Please respond as soon as possible as I am working on a time sensitive
project that depends on this.
Thank you and have a great day
Tue, 01 Jun 1999 10:18:06 -0500
Keala Jacobs <keala_jacobs@itd.sterling.com>
using variables with postgres