Postgres Pro
Downloads
Home   >   mailing lists

The same result for with SPACE and without SPACE - Mailing list pgsql-admin

From Wetmore, Matthew (CTR)
Subject The same result for with SPACE and without SPACE
Date
Msg-id 0055148e2cc742cbbc23485ae0c6c04e@express-scripts.com
Whole thread Raw
In response to Re: The same result for with SPACE and without SPACE  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: The same result for with SPACE and without SPACE
List pgsql-admin
Tree view 
I can reproduce this with a INT

-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Wednesday, June 14, 2023 3:46 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: Scott Ribe <scott_ribe@elevated-dev.com>; pgsql-admin@lists.postgresql.org
Subject: [EXTERNAL] 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:


https://urldefense.com/v3/__https://www.postgresql.org/docs/current/datatype-character.html__;!!GFE8dS6aclb0h1nkhPf9!5ahVPSTPuRxIvywc-UhqjYfqPmkGYEBT5b4GYndHqVaD0G98F0LrX6G6GgTNaJsMVaewVB5e1wox__K0nNGLZsEilYBU$


            regards, tom lane

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: The same result for with SPACE and without SPACE
Next
From: Scott Ribe
Date:
Subject: Re: The same result for with SPACE and without SPACE