2011/10/19 Tom Lane <t...@sss.pgh.pa.us>: > I wrote: >> Merlin Moncure <mmonc...@gmail.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? >
It has a CALL statement, or procedures can be called directly. Regards Pavel Stehule > regards, tom lane > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs > -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
