Re: PL/PGSQL help for getting number of rows matched. - Mailing list pgsql-general

Maybe you can use a for if there is only one row it will do the job just
like if there were many rows:

    FOR referrer_keys IN SELECT * FROM cs_referrer_keys ORDER BY try_order
LOOP
        a_output := a_output || '' IF v_'' || referrer_keys.kind || '' LIKE
''''''''''
                 || referrer_keys.key_string || '''''''''' THEN RETURN
''''''
                 || referrer_keys.referrer_type || ''''''; END IF;'';
    END LOOP;

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail