PERFORM STATEMENT

[WP]

I have a function

CREATE OR REPLACE FUNCTION rules_broken(ordref bigint)
RETURNS character varying AS

DECLARE
rules RECORD;
rulesbroken character varying;
ordsource character varying;

BEGIN

FOR rules IN SELECT rul_id,rul_sql FROM sd_stp_rules ORDER BY rul_id LOOP

EXECUTE rules.rul_sql || ' AND ord_id =' || ordref;

If found then
rulesbroken:=rulesbroken || rules.rul_id || ';';
end if;

END LOOP;

RETURN rulesbroken;
END;

In my table sd_STP_rules.rul_sql I had simple selects e.g.
SELECT COUNT(*) FROM d_order WHERE ....

This bombs. I read that I should use a PERFORM statement but again this bombs.

Anybody have a clue of the correct syntax of the PERFOM statement.

I have been trying PERFORM Select Count(*) FROM d_order WHERE ....

and also PERFORM Count(*) FROM d_order WHERE ....

but no joy

any help here would be much appreciated ...


Thanks W


WP

http://www.neptune400.com