On Fri, Dec 5, 2008 at 8:24 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:
> Scott Marlowe, 04.12.2008 16:34:
>>
>> Like an Oracle DBA who told me
>> pgsql was broken because the output of group by wasn't properly
>> ordered like it was on Oracle 9.
>
> Then he did not know Oracle very well :)
> Even Oracle 9 does not guarantee that the output of an GROUP BY is actually
> sorted, with Oracle 10 this has just gotton more "obvious" because the
> grouping strategies were enhanced.
>
yeah, that sounds merely like his short experience, or by-product of
the way GROUP BY was implemented in some particular version of oracle
9, not a guaranteed outcome. Poor guy... he probably still lives on
thinking that oracle is so good because of those little 'things' :)
--
GJ