Re: help on qouteing in plpgsql function

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: help on qouteing in plpgsql function
Дата
Msg-id 3D0DE351.F9445C1D@Yahoo.com
обсуждение исходный текст
Ответ на help on qouteing in plpgsql function  (Robert Treat <rtreat@webmd.net>)
Ответы Re: help on quoteing in plpgsql function  (Robert Treat <rtreat@webmd.net>)
Список pgsql-general
Robert Treat wrote:
>
> I think I am at the point of just guessing now, so I'm hoping someone
> can shed a little light on this. Heres the code:
>
> CREATE OR REPLACE FUNCTION purge_old_messages()
> RETURNS bool
> AS
> '[...]
>
> What I am trying to accomplish with the second sql query is:

    What about putting a

        RAISE NOTICE ''strDelete = %'', strDelete;

    before the EXECUTE and continue with try'n'error?
    Good old "printf-debugging" allways works :-)


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #

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

Предыдущее
От: "Bertin, Philippe"
Дата:
Сообщение: Re: Clients for administration?
Следующее
От: Alessio Bragadini
Дата:
Сообщение: Re: Clients for administration?