Re: Question about cost-calculation

am Mon, dem 02.06.2008, um 9:57:17 -0400 mailte Tom Lane folgendes:
> "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> writes:
> > i expected for a 1000 row test-table a cost per function of 2.5
> > (cpu_operator_cost = 0.0025), but i got 5.
>
> What's the data type of "i"? I suspect you really have two function
> calls in that expression: a type coercion function and cos() itself.

Tom, many thanks for the enlightenment, you are right. Data typ of "i"
was int, if i use real than i got the expected costs. Great ;-)

Thanks, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net