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

Once again ,

I have different logic based on match,
i need to know a prioi the number of matches.

See the actual code in response to Nigel .

Thanks for your response.

regds
mallah.

On Monday 10 Nov 2003 6:57 pm, Jaime Casanova wrote:
> 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