How to declare a variable in a postgresql query in sql language ?

Поиск
Список
Период
Сортировка
Искать
От
Sara Harris
Тема
How to declare a variable in a postgresql query in sql language ?
Дата
Msg-id
5FB88A6E864A254D8E81C2CB9707E8E88E355A54@RMLMB2.ips.gov.il
Список
Дерево обсуждения
How to declare a variable in a postgresql query in sql language ? Sara Harris <sarah@ips.gov.il>
Re: How to declare a variable in a postgresql query in sql language ? Tom Lane <tgl@sss.pgh.pa.us>

In MS SQL Server I can do this:

DECLARE @myvar INT 
SET @myvar = 5 
 
SELECT * 
FROM somewhere 
WHERE something = @myvar 

How do I do the same in PostgreSQL in sql language? According to the documentation are declared simply as "name type;", but this gives me a syntax error:

myvar INTEGER; 

 

В списке pgsql-novice по дате отправления
От: Jean-Yves F. Barbier
Дата:
От: Andreas Kretschmer
Дата:
FAQ