smallint will be out of range for this due to number of bytes and ideally its behaving same way as any ***int data type.
Boolean is not possible as this is phone number.
Please suggest
Thanks..
From: Nidhi Gupta <nidhig631@gmail.com> Sent: woensdag 20 januari 2021 12:20 To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com> Cc: pgsql-admin@postgresql.org Subject: Re: Data Type to store Leading Zero(0)
Use datatype smallint(1) for storing zero or use Boolean datatype.
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.