James,
> FOR rec IN EXECUTE
> ''select count(person_id) as total from person where person_email
> like '''''' || $1 || ''%'''' and person_id IN
> (
> select cp.person_id from cluster_person cp, cluster c where
> cp.cluster_id = c.cluster_id and c.c_id = '' || $2 || ''group by
> cp.person_id
> ) ''
> LOOP
> tot = rec.total;
> END LOOP;
>
> It works fine - I was just wondering if you can:
> 1. execute this sql without a loop being used as its not required.
Not as written, no.
> 2. could this be a straight SQL function instead( I dont think you
> can append strings together in SQL functions )
Yes, it could. If I have time later, I'll draft you an example.
-Josh