Bruno Baguette <[EMAIL PROTECTED]> writes:
> Le 27/10/08 05:16, Tom Lane a écrit :
>> Bruno Baguette <[EMAIL PROTECTED]> 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?
> I only want to know if there is at least one result for this query.
> I don't want to get the results itself.
In that case you just do EXECUTE 'SELECT ...
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
