Postgres Pro
Downloads
Home   >   mailing lists

Re: need clarification on CTE/join - Mailing list pgsql-general

From David G. Johnston
Subject Re: need clarification on CTE/join
Date
Msg-id CAKFQuwaZZgB4yfQKUjZWZGeVuki68SRFaAHOtmQkYyRAT1WXbw@mail.gmail.com
Whole thread Raw
In response to need clarification on CTE/join  (Marc Millas <marc.millas@mokadb.com>)
Responses Re: need clarification on CTE/join  (Marc Millas <marc.millas@mokadb.com>)
List pgsql-general
Tree view
On Tue, Mar 23, 2021 at 6:45 PM Marc Millas <marc.millas@mokadb.com> wrote:
So.. I would like to understand the "why" of this behaviour, ie. the change of order when I do the cast.

I believe the "why" is immaterial here.  Your queries do not contain order by so your results are unordered - even if there appears to be an apparent ordering for any particular result.

David J.

pgsql-general by date:

Previous
From: Marc Millas
Date:
Subject: need clarification on CTE/join
Next
From: Marc Millas
Date:
Subject: Re: need clarification on CTE/join