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 vote242 views1 answer
Download mysql database to excel in android studio
SQL
0 vote225 views2 answers
What is 1=2 in sql
SQL
7 votes227 views2 answers
Sql remove duplicates based on column
SQL
0 vote286 views1 answer
Microsoft sql server python connection
SQL
0 vote196 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote191 views1 answer
How to count null values in sql
SQL
-1 vote224 views1 answer
Mysql faster insert
SQL
0 vote199 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote193 views1 answer
Oracle last connection
SQL
0 vote288 views1 answer
Mysql collation portugues brasil
SQL