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

From Rajesh Kumar Mallah
Subject Re: PL/PGSQL help for getting number of rows matched.
Date
Msg-id 200311101932.23239.mallah@trade-india.com
Whole thread Raw
In response to Re: PL/PGSQL help for getting number of rows matched.  ("Jaime Casanova" <el_vigia_ec@hotmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: PL/PGSQL help for getting number of rows matched.
Next
From: Tom Lane
Date:
Subject: Re: Temp rows - is it possible?