Breaking News: Grepper is joining You.com. Read the official announcement!

postgresql variable in query

Muddy Moose answered on October 30, 2021 Popularity 10/10 Helpfulness 2/10

answer postgresql variable in query

postgresql variable in query

Comment

-2

-- 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)

Popularity 10/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: postgresql sql

Link to this answer
Share Copy Link