Re: help on qouteing in plpgsql function - Mailing list pgsql-general

From Jan Wieck
Subject Re: help on qouteing in plpgsql function
Date
Msg-id 3D0DE351.F9445C1D@Yahoo.com
Whole thread Raw
In response to help on qouteing in plpgsql function  (Robert Treat <rtreat@webmd.net>)
Responses Re: help on quoteing in plpgsql function  (Robert Treat <rtreat@webmd.net>)
List 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 by date:

Previous
From: "Bertin, Philippe"
Date:
Subject: Re: Clients for administration?
Next
From: Alessio Bragadini
Date:
Subject: Re: Clients for administration?