Re: [PLPGSQL] PERFORM into an EXECUTE allowed ?

Bruno Baguette <bruno.baguette@gmail.com> writes:
> EXECUTE 'PERFORM COUNT(*)'
>       || ' FROM ' || quote_ident(TG_RELNAME)
>       || ' GROUP BY ' || quote_ident(column_name_to_check)
>       || ' HAVING COUNT(*) > 1';

PERFORM is a plpgsql keyword, not a SQL keyword, so it's not surprising
that this fails.  What I'm wondering is what exactly you hope the above
will accomplish?  Why would you want to execute this query only to have
the results discarded?

            regards, tom lane