Search Postgresql Archives

Re: need clarification on CTE/join

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Mar 23, 2021 at 6:45 PM Marc Millas <marc.millas@xxxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux