gset-1.sql

application/x-sql

Download

SELECT 1 AS a \gset
\set i debug(:a)
SELECT 2 AS a \cset
SELECT 3;
\set i debug(:a)
SELECT 2 AS x \;
SELECT 3 AS a \cset
SELECT 4;
\set i debug(:a)
SELECT 3 \;
SELECT 4 AS x \cset
SELECT 5 AS y \cset
SELECT 6 AS z \gset
\set i debug(:x)
\set i debug(:y)
\set i debug(:z)
SELECT 7 AS w \gset
SELECT 8 AS w \gset p
SELECT 'hello' \;
SELECT 'world' \;
SELECT 9 AS m, 10 AS n \cset p
SELECT 'x' AS n;
\set i debug(:w)
\set i debug(:pw)
\set i debug(:pm)
\set i debug(:pn)