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