I can reproduce this with a INT -----Original Message----- From: Tom Lane <tgl@xxxxxxxxxxxxx> Sent: Wednesday, June 14, 2023 3:46 PM To: M Sarwar <sarwarmd02@xxxxxxxxxxx> Cc: Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx Subject: [EXTERNAL] Re: The same result for with SPACE and without SPACE M Sarwar <sarwarmd02@xxxxxxxxxxx> writes: > I expect this to behave the same way whether it comes from CHAR or VARCHAR. You expect incorrectly. CHAR comparison is insensitive to trailing spaces: https://urldefense.com/v3/__https://www.postgresql.org/docs/current/datatype-character.html__;!!GFE8dS6aclb0h1nkhPf9!5ahVPSTPuRxIvywc-UhqjYfqPmkGYEBT5b4GYndHqVaD0G98F0LrX6G6GgTNaJsMVaewVB5e1wox__K0nNGLZsEilYBU$ regards, tom lane
