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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, depstein(at)alliedtesting(dot)com, pgsql-bugs(at)postgresql(dot)org, pgagarinov(at)alliedtesting(dot)com, vshahov(at)alliedtesting(dot)com
Subject: Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Date: 2011-10-19 21:23:23
Message-ID: 19857.1319059403@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
I wrote:
> Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
>> The point being, how do I convert any query to a non WITH variant so
>> it can be PERFORM'd?  Anyways, I always thought having to do perform
>> at all was pretty weak sauce -- not sure why it's required.

> Possibly it was an Oracle compatibility thing ... anyone know PL/SQL
> well enough to say how this works there?

After writing that, I remembered I had an old PL/SQL manual sitting
about, so I took a look.  So far as I can see, there is no PERFORM
statement in PL/SQL, and no SELECT-without-INTO either; that is, the
functionality of executing a SELECT and discarding the result simply
isn't there.

So at this point it looks like we made up PERFORM out of whole cloth,
and we could just as easily choose to do it another way.  Jan, do you
remember anything about the reasoning for PERFORM?

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Craig RingerDate: 2011-10-20 03:51:52
Subject: Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Previous:From: Kevin GrittnerDate: 2011-10-19 21:21:54
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