From: Tom Lane <tgl@sss.pgh.pa.us> Sent: Wednesday, June 14, 2023 6:45 PM To: M Sarwar <sarwarmd02@outlook.com> Cc: Scott Ribe <scott_ribe@elevated-dev.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org> Subject: Re: The same result for with SPACE and without SPACE
M Sarwar <sarwarmd02@outlook.com> 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: