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 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 по дате отправления