Обсуждение: using variables with postgres

Поиск
Список
Период
Сортировка

using variables with postgres

От
Keala Jacobs
Дата:
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


Вложения