Postgres Pro
Downloads
Home   >   mailing lists

Clarify the ordering guarantees in combining queries (or lack thereof) - Mailing list pgsql-docs

From Shay Rojansky
Subject Clarify the ordering guarantees in combining queries (or lack thereof)
Date
Msg-id CADT4RqD0oWGCeSdGtN3UEH21HxF=1Svbr3dvEL9ueuEr-x5L4g@mail.gmail.com
Whole thread Raw
Responses Re: Clarify the ordering guarantees in combining queries (or lack thereof)  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-docs
Tree view
Greetings.

I was trying to understand what - if any - are the guarantees with regards to ordering for combining queries (UNION/UNION ALL/...). From this message[1], it seems that UNION ALL does preserve the ordering of the operand queries, whereas UNION does not (presumably neither do INTERSECT, INTERSECT ALL, EXCEPT and EXCEPT ALL).

The documentation[2] makes no mention of this, I'd suggest adding a note clarifying this.

Thanks,

Shay

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: "Getting Started" guide is missing a critical step?
Next
From: "David G. Johnston"
Date:
Subject: Re: Clarify the ordering guarantees in combining queries (or lack thereof)