Vitaly Belman <vitalyb@gmail.com> writes:
> My bad. Here we go, really simple:
> CREATE OR REPLACE FUNCTION public.bayes_books(float4, int4)
> RETURNS float8 AS
> 'select bayes($1, $2, 5, 3.9)'
^^^^^^^^^^^^
> LANGUAGE 'sql' IMMUTABLE;
> CREATE OR REPLACE FUNCTION functions.bayes(float4, int4, int4, float4)
^^^^^^^^^^^^^^^
> RETURNS float8 AS
> 'select ($2 / ($2+$3::float4)) * $1 + ($3 / ($2+$3::float4)) * $4'
> LANGUAGE 'sql' IMMUTABLE;
I'll bet that the "functions" schema wasn't in your search path when you
did the VACUUM. It would be wiser to write "functions.bayes(...)" in
the bayes_books function, so it wouldn't be context-dependent.
regards, tom lane
