Re: [SQL] Ordering in an aggregate -- points to paths

2003-06-16 Thread Julian Scarfe
From: "Tom Lane" <[EMAIL PROTECTED]> > Yeah, this is a fairly obvious thing to want to do with a user-written > aggregate. It does not work in released versions, because the planner > does not notice that the inner SELECT's output ordering matches what > the GROUP BY needs, and so it inserts an a

Re: [SQL] Ordering in an aggregate -- points to paths

2003-06-15 Thread Tom Lane
"Julian Scarfe" <[EMAIL PROTECTED]> writes: > OK, I know relying on ordering in an aggregate is sinful, but I don't know > if it's mortal or venial. > ... > SELECT c.fir_ident, c.fir_indicator, create_path (c.node) AS fir_edge >INTO fir_e >FROM >(SELECT fir_ident, fir_indica