Re: replacing a function called "isnull" reports an error

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, butthe system could not accept to create a function if
it cannot drop it (I guess).
Thanks again.
--- Tom Lane <tgl@sss.pgh.pa.us> escreveu:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > César Arnold wrote:
> >> Hi, I created a function called "isnull" for test
> >> purposes and when trying to replace it returns
> the
> >> message belows :
>
> > ISNULL is a reserved word.  You need to quote the
> name or pick a
> > different one.
>
> 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
>


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