Postgres Pro
Downloads
Home   >   mailing lists

Re: Declaring a constant or variable in a query - Mailing list pgsql-sql

From Greg Sabino Mullane
Subject Re: Declaring a constant or variable in a query
Date
Msg-id CAKAnmmKVdAgEdDYhyxnHuks_d=xdEY0_Q1GZy9ab8rVqM9mhpg@mail.gmail.com
Whole thread Raw
In response to Declaring a constant or variable in a query  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-sql
Tree view
Not sure how exactly DataGrip works for prompting input, but a CTE should allow you to declare the constant once:

WITH x AS (SELECT :myinput AS alias5)
SELECT fld1 as alias1, fld2 as alias2, fld3 as alias3, fld4 as alias4, alias5 FROM table1, x WHERE condition1
UNION
SELECT fld1 as alias1, fld2 as alias2, fld3 as alias3, fld4 as alias4, alias5 FROM table2, x WHERE condition2
UNION
SELECT fld1 as alias1, fld2 as alias2, fld3 as alias3, fld4 as alias4, alias5 FROM table3, x WHERE condition3
UNION
SELECT fld1 as alias1, fld2 as alias2, fld3 as alias3, fld4 as alias4, alias5 FROM table4, x WHERE condition4

Cheers,
Greg

pgsql-sql by date:

Previous
From: JORGE MALDONADO
Date:
Subject: Declaring a constant or variable in a query
Next
From: Shaozhong SHI
Date:
Subject: Very odd message