BUG #18523: String compare not consistent
От | PG Bug reporting form |
---|---|
Тема | BUG #18523: String compare not consistent |
Дата | |
Msg-id | 18523-d7b3cacb64d91cda@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #18523: String compare not consistent
Re: BUG #18523: String compare not consistent Re: BUG #18523: String compare not consistent |
Список | pgsql-bugs |
The following bug has been logged on the website: 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 <...
В списке pgsql-bugs по дате отправления: