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

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: PL/PGSQL help for getting number of rows matched.
Дата
Msg-id BAY8-F42gXOoE4zyYJO00000b70@hotmail.com
обсуждение исходный текст
Ответ на PL/PGSQL help for getting number of rows matched.  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Ответы Re: PL/PGSQL help for getting number of rows matched.  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: PL/PGSQL help for getting number of rows matched.
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: PL/PGSQL help for getting number of rows matched.