Re: [SQL] argument type problem with plpgsql function

2005-11-22 Thread Luca Pireddu
On November 22, 2005 20:24, Tom Lane wrote: > Luca Pireddu <[EMAIL PROTECTED]> writes: > > I just tried it at home on a postgresql 8.0.3 server (debian package) and > > it worked the way it's supposed to. Puzzling... > > Maybe you have more than one blast_evalue() function with different > argumen

Re: [SQL] argument type problem with plpgsql function

2005-11-22 Thread Tom Lane
Luca Pireddu <[EMAIL PROTECTED]> writes: > I just tried it at home on a postgresql 8.0.3 server (debian package) and it > worked the way it's supposed to. Puzzling... Maybe you have more than one blast_evalue() function with different argument types? regards, tom lane -

Re: [SQL] argument type problem with plpgsql function

2005-11-22 Thread Luca Pireddu
On November 22, 2005 17:13, Stephan Szabo wrote: > On Tue, 22 Nov 2005, Luca Pireddu wrote: > [snip] > > I got the same answer (the second) for both calls from my 8.0 and 8.1 > setups, what version were you trying on? > I forgot to mention that. I'm using version 8.0.4, built from source. I just

Re: [SQL] argument type problem with plpgsql function

2005-11-22 Thread Stephan Szabo
On Tue, 22 Nov 2005, Luca Pireddu wrote: > I wrote a little function that has to work with big numbers > > CREATE OR REPLACE FUNCTION blast_evalue(seq_len bigint, db_size bigint, > bit_score double precision) > RETURNS double precision AS $$ > BEGIN > RETURN 2^(bit_score) * db_size * seq_len;