Re: Sorted union

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Sorted union
Date: 2005-11-03 18:37:52
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3417DD7A0@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> The ANSI/ISO specs are not at all ambiguous on this. An
> ORDER BY is not allowed for the SELECT statements within
> a UNION. It must come at the end and applied to the resulting
> UNION.

Interesting :/

Merlin

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2005-11-03 18:42:08 Re: insert performance for win32
Previous Message Kevin Grittner 2005-11-03 18:32:06 Re: Sorted union