Bruno Baguette <bruno.baguette@xxxxxxxxx> writes: > Le 27/10/08 05:16, Tom Lane a écrit : >> Bruno Baguette <bruno.baguette@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
