The following bug has been logged on the website:
Bug reference: 16083
Logged by: Eka Setiawan Saputra
Email address: mr(dot)poetra22(at)gmail(dot)com
PostgreSQL version: 9.6.15
Operating system: Linux & Windows
Description:
This query is show different result ordering on windows and linux
SELECT * FROM (
SELECT '{A}' AS Y UNION
SELECT '{A, AA}' AS Y UNION
SELECT '{A, AA, AAA}' AS Y
) X
ORDER BY Y ASC