Re: select function & search_path problem/bug?

ivan wrote:
> hi,
> 
> i have a problem with selecting function :
> 
> db=# select auxilium.exists('arx.mods', 'r');
>  exists
> --------
>  t
> (1 row)
> 
> db=# select exists('arx.mods', 'r');
> ERROR:  syntax error at or near "'arx.mods'" at character 15

I believe the problem here is that exists is a reserved word (as in 
SELECT ... FROM ... WHERE EXISTS ...)

I think you should be ok if you quote your function name  SELECT "exists"(...)
Personally, I'd change it's name.

--   Richard Huxton  Archonet Ltd