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 vote104 views1 answer
Calculate discount from original price sql
SQL
2 votes222 views1 answer
Oracle run_duration to number
SQL
2 votes156 views1 answer
Sql string_agg
SQL
0 vote164 views1 answer
Count database access django
SQL
0 vote172 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote206 views1 answer
Replace null value within column mysql
SQL
0 vote152 views1 answer
Mysqlimport
SQL
0 vote141 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
17 votes170 views6 answers
Sql current date
SQL
3 votes182 views2 answers
Brew restart mysql
SQL