Postgres Pro
Downloads
Home   >   mailing lists

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

From M Sarwar
Subject Re: The same result for with SPACE and without SPACE
Date
Msg-id DM4PR19MB59784B518F25D2C2292CA3FBD35AA@DM4PR19MB5978.namprd19.prod.outlook.com
Whole thread Raw
In response to Re: The same result for with SPACE and without SPACE  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: The same result for with SPACE and without SPACE
Re: The same result for with SPACE and without SPACE
Re: The same result for with SPACE and without SPACE
List pgsql-admin
Tree view
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?


pgsql-admin by date:

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