Postgres Pro
Downloads
Home   >   mailing lists

Re: PERFORM statement question - Mailing list pgsql-novice

From Tom Lane
Subject Re: PERFORM statement question
Date
Msg-id 12813.1103245699@sss.pgh.pa.us
Whole thread Raw
In response to PERFORM statement question  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgsql-novice
Tree view 
"Keith Worthington" <keithw@narrowpathinc.com> writes:
>          PERFORM SELECT peachtree.tbl_gl_account.account_id
>                    FROM peachtree.tbl_gl_account
>                   WHERE peachtree.tbl_gl_account.account_id =
> rcrd_gl_account.account_id;

You just want "PERFORM peachtree...", that is, the PERFORM keyword
is syntactically a substitute for SELECT.  The manual is not very
good about this :-( ... I've tried to make it clearer in the 8.0
docs.

            regards, tom lane

pgsql-novice by date:

Previous
From: John DeSoi
Date:
Subject: Re: basic download and setup questions
Next
From: "Keith Worthington"
Date:
Subject: Re: PERFORM statement question