Thread: Re: [SQL] 'cost' and 'rows' for volitile function

Old fool that I am - forgot to cc: the list.

Richard Huxton wrote:
> Rob Sargent wrote:
>> pg-admin is showing 'COST 100' and 'ROWS 1000' for my explicitly
>> VOLATILE functions.  Is one hundred the new ninety-nine? and therefore
>> these values are ignored by the planner?
>
> No, they're the default expected cost and number of rows returned when
> calling your functions. What do you think VOLATILE should be doing to them?
>
> http://www.postgresql.org/docs/8.3/interactive/sql-createfunction.html


--
   Richard Huxton
   Archonet Ltd