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

8 votes235 views2 answers
Oracle auto increment primary key
SQL
1 vote268 views1 answer
Sql random sampling per group
SQL
0 vote244 views1 answer
Mysql update set sum
SQL
2 votes258 views1 answer
Drop all foreign key constraints mysql
SQL
1 vote223 views1 answer
Mysql count words
SQL
0 vote191 views1 answer
Mysql select top 2
SQL
0 vote231 views2 answers
Create sequence if not exists postgres
SQL
0 vote240 views1 answer
Sqlite version check
SQL
0 vote258 views4 answers
Restart MySQL
SQL
1 vote258 views3 answers
Mysql on delete set null
SQL