Quick Links

Data Type to store Leading Zero(0)

From:	<soumik(dot)bhattacharjee(at)kpn(dot)com>
To:	<pgsql-admin(at)postgresql(dot)org>
Subject:	Data Type to store Leading Zero(0)
Date:	2021-01-20 11:13:34
Message-ID:	c77968e8e35a4e9d8f68c2683ae1b807@kpn.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

Hello Experts,

As per business needs we need to store Zero(0) in primary key column of table with this kind of value --> 07******** with applications written in Java microservices.

We are not able to use numeric data type as it trims the Zero value in leading, but it's also a performance impact if we define varchar in the data type.

Please suggest.

Thanks

Responses

Re: Data Type to store Leading Zero(0) at 2021-01-20 11:20:20 from Nidhi Gupta
Re: Data Type to store Leading Zero(0) at 2021-01-20 12:39:50 from Thomas Kellerer
Re: Data Type to store Leading Zero(0) at 2021-01-20 14:49:34 from David G. Johnston
RE: Data Type to store Leading Zero(0) at 2021-01-22 07:57:25 from Michel SALAIS

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Nidhi Gupta	2021-01-20 11:20:20	Re: Data Type to store Leading Zero(0)
Previous Message	William Sescu (Suva)	2021-01-20 08:56:02	3 Parameters in pg_settings in CamelCase