Thanks for this email.
I am checking all the emails.
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Sent: Wednesday, June 14, 2023 6:45 PM
To: M Sarwar <sarwarmd02@xxxxxxxxxxx>
Cc: Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: 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
regards, tom lane