replacing a function called "isnull" reports an error - Mailing list pgsql-bugs

From César Arnold
Subject replacing a function called "isnull" reports an error
Date
Msg-id 20040821162456.66960.qmail@web14930.mail.yahoo.com
Whole thread Raw
Responses Re: replacing a function called "isnull" reports an error  (Peter Eisentraut <peter_e@gmx.net>)
List 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/


pgsql-bugs by date:

Previous
From: "Bellan Saravanan"
Date:
Subject: Postgres 8.0/Windows 2000 Load testing
Next
From: Guenter Abraham
Date:
Subject: ecpg / libecpg.dll