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 vote1.2K views1 answer
Mysql custom sort order
SQL
1 vote316 views2 answers
Reset mysqli fetch_arra
SQL
0 vote352 views1 answer
How to find table lock and row lock in mysql
SQL
20 votes337 views4 answers
Sqlite create table if not exists
SQL
1 vote336 views1 answer
Alter constraint postgres
SQL
1 vote333 views2 answers
Create a unqie constraint mysql
SQL
12 votes327 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote332 views1 answer
Test connection to sql server
SQL
0 vote340 views1 answer
Narural join
SQL
0 vote351 views1 answer
SAP Return
SQL