Bug reference: 18523 Logged by: Patrick van Dijk Email address: patrick.van.dijk@gmail.com PostgreSQL version: 16.3 Operating system: Windows vs Linux/Azure Description:
When I try the following on a Azure/Linux version of PostgreSQL i see some strange results that are not correct. On Windows the behavior is correct.
select '|' < '0'; -- true, true, this is correct select '|1' < '01'; -- false, true, Azure/Linux is wrong select '||' < '0|'; -- true, true, this is correct select '||1' < '0|1'; -- false, true, Azure/Linux is wrong
When the first character compares <, then no matter what follows, it should be <...
