Postgres Pro
Downloads
Home   >   mailing lists

Re: Sorted union - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Sorted union
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD7A0@Herge.rcsinc.local
Whole thread Raw
In response to Sorted union  (Scott Lamb <slamb@slamb.org>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Sorted union
Next
From: "Merlin Moncure"
Date:
Subject: Re: insert performance for win32