On Thu, Jul 26, 2012 at 08:31:13AM +0200, Pavel Stehule wrote: > 2012/7/26 David Fetter <da...@fetter.org>: > > On Thu, Jul 26, 2012 at 01:36:17AM -0400, Tom Lane wrote: > >> Pavel Stehule <pavel.steh...@gmail.com> writes: > >> > \eset variable [, variable [..]] query -- it raise exception when > >> > more than one row is returned or when no row is returned > >> > >> Better would be a variant on \g, that is you type in the query and > >> then tell it where to put the result. We have learned the hard way > >> that putting SQL commands into the arguments of backslash commands > >> is a horrid idea. Maybe > >> > >> select x,y,... from ... > >> \gset var1 var2 ... > > > > 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? Cheers, David. P.S. The bike shed should be puce with blaze orange pin-striping. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers