Re: [GENERAL] Question about cost-calculation

2008-06-02 Thread A. Kretschmer
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 fun

Re: [GENERAL] Question about cost-calculation

2008-06-02 Thread Tom Lane
"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.