Re: [HACKERS] PERFORM effects FOUND patch (Was: I must be

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: Alvaro Herrera <alvherre(at)atentus(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Joe Conway <mail(at)joeconway(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] PERFORM effects FOUND patch (Was: I must be
Date: 2002-06-17 13:38:36
Message-ID: 3D0DE65C.5876FDC4@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

"Nigel J. Andrews" wrote:
>
> On Fri, 14 Jun 2002, Alvaro Herrera wrote:
>
> > Tom Lane dijo:
> >
> > > "Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)uk> writes:
> > > > However, because PERFORM discards the results of a query it is only
> > > > useful for side effects of the query.
> >
> > > Okay. I guess the next question is whether PERFORM *should* be setting
> > > FOUND. Seems like it might be a reasonable thing to do.
> >
> > Well, actually FOUND _is_ a side effect of PERFORM, IMHO. I also tried
> > to do the very same thing, and also had to use the dummy variable, which
> > seems like a waste to me.
> >
> > I do not know anything about Oracle's PERFORM, though a quick search on
> > Google shows nothing relevant.
>
> I know nothing of Oracle's use of PERFORM either. Indeed I have looked in 4
> Oracle books 'Oracle 8i The Complete Reference', 'Oracle8i DBA Bible', 'Oracle
> PL/SQL Language Pocket Reference' and one on PL/SQL Builtins (on the off
> chance), and couldn't find any reference to PERFORM. I even scanned, by eye,
> every page of the PL/SQL reference and saw nothing.

Perform has nothing to do with ORACLE. It was added because people tried
to call other "procedures" and didn't want any result back. Using

SELECT function();

didn't look right, so we made it

PERFORM function();

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tycho Fruru 2002-06-17 13:39:35 Re: Postgres DB recompilation
Previous Message Doug McNaught 2002-06-17 13:37:16 Re: Postgres DB recompilation

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-06-17 13:40:24 Re: SetQuerySnapshot, once again
Previous Message Michael Meskes 2002-06-17 13:27:37 Re: PostGres Doubt