Re: Catching dangling LOBs?

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;
ALTER FUNCTION public.bayes_books(float4, int4) OWNER TO postgres;

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;
ALTER FUNCTION functions.bayes(float4, int4, int4, float4) OWNER TO postgres;

-----------------------------------------

Thanks =)

On 4/16/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Vitaly Belman <vitalyb@gmail.com> writes:
> > Failed to check book_picture in table public.books:
> > ERROR:  function bayes(real, integer, integer, numeric) does not exist
> > HINT:  No function matches the given name and argument types. You may need to ad
> > d explicit type casts.
> > CONTEXT:  SQL function "bayes_books" during inlining
>
> Can't help you with this when you didn't show us either function.
>
>                         regards, tom lane
>


--
 ICQ: 1912453
 AIM: VitalyB1984
 MSN: tmdagent@hotmail.com
 Yahoo!: VitalyBe