Re: [GENERAL] PL/PGSQL help for getting number of rows matched.

[Jaime Casanova]

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org