That was the problem. Thanks =).
P.S Still a bit strange because "functions" IS in the search_path,
there is no reason for it not to find it from the vacuum.
On 4/16/05, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> Vitaly Belman <vitalyb@xxxxxxxxx> 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
>
--
ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent@xxxxxxxxxxx
Yahoo!: VitalyBe
---------------------------(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
