Re: help on qouteing in plpgsql function

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(at)Yahoo(dot)com #