[SQL] 'cost' and 'rows' for volitile function

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:

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

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

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

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

Re: [SQL] Xml Schemas

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