Skip site navigation (1) Skip section navigation (2)

Re: Can't use WITH in a PERFORM query in PL/pgSQL?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Merlin Moncure" <mmoncure(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <depstein(at)alliedtesting(dot)com>,<pgagarinov(at)alliedtesting(dot)com>, <vshahov(at)alliedtesting(dot)com>, "Robert Haas" <robertmhaas(at)gmail(dot)com>, "Bruce Momjian" <bruce(at)momjian(dot)us>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Date: 2011-10-19 21:21:54
Message-ID: 4E9EF922020000250004225E@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
 
> I think it wouldn't be an unreasonable thing to just interpret a
> SELECT with no INTO clause as being a PERFORM (ie execute and
> discard results).
 
FWIW, that would probably confuse people coming from MS SQL Server
or Sybase ASE, since doing that in Transact-SQL would return a
result set.  Any stored procedure can produce an arbitrarily
intermixed stream of result sets, information lines, and error
messages.
 
-Kevin

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-10-19 21:23:23
Subject: Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Previous:From: Tom LaneDate: 2011-10-19 20:45:58
Subject: Re: Can't use WITH in a PERFORM query in PL/pgSQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group