On 2017-Nov-04, Fabien COELHO wrote: > Think of one initialization followed by two appends: > > SELECT 1 AS x \cset > SELECT 2 \; SELECT 3 AS y \cset > SELECT 4 \; SELECT 5 \; SELECT 6 AS z \gset > > In the end, we must have the full 6 queries > > "SELECT 1 AS x \; SELECT 2 \; SELECT 3 AS y \; SELECT 4 \; SELECT 5 \; > SELECT 6 AS z" > > and know that we want to set variables from queries 1, 3 and 6 and ignore > the 3 others.
I'm not sure I understand this. Why is the "SELECT 2" ignored? (I can see why the 4 and 5 are ignored: they are not processed by gset). What exactly does \cset do? I thought "SELECT 2 \; SELECT 3 AS y \cset" would search for the \; and process *both* queries. I think the doc addition should be split. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
