replacing a function called "isnull" reports an error

From: César Arnold <cesararnold(at)yahoo(dot)com(dot)br>
To: pgsql-bugs(at)postgresql(dot)org
Subject: replacing a function called "isnull" reports an error
Date: 2004-08-21 16:24:56
Message-ID: 20040821162456.66960.qmail@web14930.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi, I created a function called "isnull" for test
purposes and when trying to replace it returns the
message belows :

-- Function: public.isnull(anyelement)

-- DROP FUNCTION public.isnull(anyelement);

CREATE OR REPLACE FUNCTION public.isnull(anyelement)
RETURNS bool AS
'
SELECT $1 is null;
'
LANGUAGE 'sql' VOLATILE;

ERROR: syntax error at or near "isnull" at character
120

Thanks.




_______________________________________________________
Yahoo! Acesso Grátis - navegue de graça com conexão de qualidade!
http://br.acesso.yahoo.com/

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Paul Gimpelj 2004-08-21 17:29:51 Re: [BUGS] postgresql 8.0b1 Win32 observations
Previous Message Thomas Wegner 2004-08-21 13:28:00 pg_dumpall win32: could not translate host name "abc.def.de" to address: Unknown host