Re: The same result for with SPACE and without SPACE

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(at)elevated-dev(dot)com>
Sent: Wednesday, June 14, 2023 6:18 PM
To: M Sarwar <sarwarmd02(at)outlook(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: The same result for with SPACE and without SPACE

Did you use type char instead of varchar?