am Mon, dem 02.06.2008, um 9:57:17 -0400 mailte Tom Lane folgendes: > "A. Kretschmer" <andreas.kretschmer@xxxxxxxxxxxxxx> 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
