am Mon, dem 02.06.2008, um 9:57:17 -0400 mailte Tom Lane folgendes: > "A. Kretschmer" <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
