Re: The same result for with SPACE and without SPACE

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

@Tom Lane

Thanks for this email.

I am checking all the emails.

Sincerely,

Sarwar

---

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
spaces:

https://na01.safelinks.protection.outlook.com/?url="">

                        regards, tom lane