Re: Using perform in plpgsql throws compile errors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mail <mail(at)peneios(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Using perform in plpgsql throws compile errors
Date: 2004-09-24 18:47:01
Message-ID: 1601.1096051621@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

mail <mail(at)peneios(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Kumar S 2004-09-24 21:08:31 creating a view from multiple tables (13 tables)
Previous Message mail 2004-09-24 17:58:35 Using perform in plpgsql throws compile errors