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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
