Postgres Pro
Downloads
Home   >   mailing lists

Re: Using perform in plpgsql throws compile errors - Mailing list pgsql-novice

From Tom Lane
Subject Re: Using perform in plpgsql throws compile errors
Date
Msg-id 1601.1096051621@sss.pgh.pa.us
Whole thread Raw
In response to Using perform in plpgsql throws compile errors  (mail <mail@peneios.com>)
List pgsql-novice
Tree view 
mail <mail@peneios.com> writes:
>     PERFORM SELECT * FROM transactions x INNER JOIN tx_items i ON(x.id =
> i.tx_id) where i.archive_id=aID and x.status=\'valid\' and x.person_id=pID;

You need "PERFORM * FROM transactions ...".  No SELECT keyword.

Looking at the manual, I see it could be worded better.  The example is
correct but the description is misleading :-(

            regards, tom lane

pgsql-novice by date:

Previous
From: mail
Date:
Subject: Using perform in plpgsql throws compile errors
Next
From: Kumar S
Date:
Subject: creating a view from multiple tables (13 tables)