Re: Using perform in plpgsql throws compile errors

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