El Thursday 04 January 2001 08:50, Megalex escribió:
> i already tried escaping it.. but the problem is
> with the singlequote-backslash-singlequote combinations..
I use something like this, and works fine for me:
create function quote(text)
returns text
as '
DECLARE
quote text;
BEGIN
quote := ichar(39); -- quote
return quote || $1 || quote;
END;'
language 'plpgsql';
--
Saludos, lmc(at)nova(dot)es
_________________________________________________________________
I've lost my faith in nihilism