gset-1.sql

application/x-sql

Filename: gset-1.sql

Type: application/x-sql

Part: 1

Message: Re: pgbench - allow to store select results into variables

SELECT 1 AS a \gset
\set i debug(:a)
SELECT 2 AS a \gcset
SELECT 3;
\set i debug(:a)
SELECT 2 AS x \;
SELECT 3 AS a \gcset
SELECT 4;
\set i debug(:a)
SELECT 3 \;
SELECT 4 AS x \gcset
SELECT 5 AS y \gcset
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 \gcset p
SELECT 'x' AS n;
\set i debug(:w)
\set i debug(:pw)
\set i debug(:pm)
\set i debug(:pn)