Postgresql variable in query

Postgres declare variable

WITH myconstants (var1, var2) as (
   values (5, 'foo')
)
SELECT *
FROM somewhere, myconstants
WHERE something = var1
   OR something_else = var2;

Postgresql variable in query

-- with myVar as (select "any value really")
-- 		then, to get access to the value stored in this construction, you do
-- 			(select * from myVar)
-- for example

with var as (select 123)    
... where id = (select * from var)

-- You could event re-cast the value (e.g. from INT to VARCHAR) 
with var as (select 123)    
... where id = ((select * from var)::VARCHAR)

Source: stackoverflow.com

Similar codes

0 vote216 views1 answer
Second Step in installing SQL workbench
SQL
1 vote195 views1 answer
How to drop function in sql
SQL
0 vote207 views1 answer
ACCEPT nome PROMPT on oracle
SQL
7 votes200 views2 answers
N highest salary in sql
SQL
0 vote255 views1 answer
Sql count matching group by
SQL
21 votes255 views3 answers
Average sql
SQL
34 votes245 views6 answers
Alter table add foreign key mysql
SQL
41 votes281 views6 answers
Alter table add column in SQL Server
SQL
8 votes179 views1 answer
Oracle add month
SQL
0 vote305 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL