On Fri, Mar 04, 2011 at 01:41:34PM -0800, Matt Warner wrote:
> No luck:
>
> *** as postgres
> postgres=# GRANT all on function nvl(anyelement,anyelement) to public;
> GRANT
> postgres=#
>
> *** as unprivileged user
> offload=> select nvl(0,1);
> ERROR: function nvl(integer, integer) does not exist
> LINE 1: select nvl(0,1);
> ^
> HINT: No function matches the given name and argument types. You might need
> to add explicit type casts.
Is the function in your search_path?
A
--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca