Bruno Baguette <bruno(dot)baguette(at)gmail(dot)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
In response to
pgsql-general by date
|Next:||From: Ron Mayer||Date: 2008-10-27 07:34:16|
|Subject: Re: Are there plans to add data compression feature to
|Previous:||From: Bruno Baguette||Date: 2008-10-27 03:39:03|
|Subject: [PLPGSQL] PERFORM into an EXECUTE allowed ?|