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 vote156 views1 answer
Plsql find location of procedure
SQL
2 votes145 views1 answer
Oracle virtual column
SQL
0 vote165 views1 answer
Add a new column into table
SQL
0 vote173 views1 answer
Oracle job session
SQL
1 vote178 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote163 views1 answer
Sql convert float to string
SQL
0 vote111 views0 answer
SQL
0 vote156 views1 answer
Virtuoso sql query tutorial
SQL
11 votes326 views4 answers
Round in sql
SQL
56 votes395 views5 answers
Psql create user
SQL