Re: proposal - assign result of query to psql variable

Pavel Stehule <pavel.stehule@gmail.com> writes:
> 2012/7/26 David Fetter <david@fetter.org>:
>>>> How about
>>>> \gset var1,,,var2,var3...

>>> I don't like this - you can use fake variable - and ignoring some
>>> variable has no big effect on client

>> Why assign to a variable you'll never use?

> so why you get data from server, when you would not to use it ?

Yeah.  I don't see why you'd be likely to write a select that computes
columns you don't actually want.

> Tom - your proposal release of stored dataset just before next
> statement, not like now on the end of statement?

Huh?  I think you'd assign the values to the variables and then PQclear
the result right away.
        regards, tom lane