On Saturday 06 June 2009 22:53:19 Isaac Dover wrote:
> Hello, I am attempting to build an xml representation of any database, but
> I'm having trouble doing so. I was interested in using the existing xml
> functions, such as "schema_to_xmlschema", but the results are strange and
> unusable. The res
Rob Sargent wrote:
Richard Huxton wrote:
If your functions are all called at the top-level then indeed it
doesn't matter. At a low level though, telling the planner function F1
costs 1000 times more than F2 is useful.
What scares me about this is that for function such as the ones I'm
curren
Rob Sargent wrote:
Richard Huxton wrote:
Rob Sargent wrote:
pg-admin is showing 'COST 100' and 'ROWS 1000' for my explicitly
VOLATILE functions.
Thanks for the pointer back to CREATE FUNCTION docs. That would have
told me that those value are indeed the defaults. I guess I'm somewhat
sur
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?
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postg
