Scott,
This is coming from CHAR(10).
test_number character(10) COLLATE pg_catalog."default",
I expect this to behave the same way whether it comes from CHAR or VARCHAR.
Does that matter?
Thanks,
Sarwar
From: Scott Ribe <scott_ribe@elevated-dev.com>
Sent: Wednesday, June 14, 2023 6:18 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: The same result for with SPACE and without SPACE
Did you use type char instead of varchar?