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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
