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/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

César Arnold wrote:
ISNULL is a reserved word. You need to quote the name or pick a
different one.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Peter Eisentraut <peter_e (AT) gmx (DOT) net> writes:
I think what he's unhappy about is this inconsistency:

regression=# create function isnull(int) returns bool as 'select $1 is null' language sql;
CREATE FUNCTION
regression=# drop function isnull(int);
DROP FUNCTION
regression=# create function public.isnull(int) returns bool as 'select $1 is null' language sql;
ERROR: syntax error at or near "isnull" at character 24
LINE 1: create function public.isnull(int) returns bool as 'select $...
^
regression=#

ISNULL is a func_name_keyword, so it's legal standing on its own, but we
only allow ColId in a qualified name. Possibly that could be relaxed.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Thanks Tom,
I'm trying to drop the function and it's giving a
similar message that the function cannot be dropped
....

I have supposed that "isnull" was a reserved word, but
the system could not accept to create a function if
it cannot drop it (I guess).
Thanks again.

--- Tom Lane <tgl (AT) sss (DOT) pgh.pa.us> escreveu:




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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly