Bug reference: 17676 Logged by: Rob Johnson Email address: robj@hightouchinc.com PostgreSQL version: 14.5 Operating system: Ubuntu Description:
No tables are needed. Just ran this, comparing strings with lower-case 'x' and period '.' characters. The first two columns are false as expected, the last column is true, which appears to be wrong.
=> select '.' > 'x' as first, '.x' > 'x.' as second, '.xx' > 'x..' as third;