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).
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> escreveu:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > César Arnold wrote:
> >> Hi, I created a function called "isnull" for test
> >> purposes and when trying to replace it returns
> >> 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
> 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 $...
> 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!
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2004-08-26 02:25:42|
|Subject: Re: server crash in very big transaction [postgresql 8.0beta1] |
|Previous:||From: Stephan Szabo||Date: 2004-08-26 02:14:25|
|Subject: Re: BUG #1231: Probelm with transactions in stored code.|