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

5 votes181 views1 answer
Sql add column after another
SQL
0 vote184 views1 answer
Mysql export search results
SQL
0 vote258 views1 answer
Mysql disable triggers
SQL
5 votes209 views1 answer
Oracle asynchronous query
SQL
1 vote241 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
-1 vote188 views1 answer
How to dump .csv file into mysql
SQL
0 vote177 views1 answer
Create table with primary key and foreign key in sql server
SQL
1 vote209 views1 answer
Events mysql
SQL
3 votes168 views1 answer
Sql select all
SQL
1 vote183 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL