Re: Data Type to store Leading Zero(0)
| От | David G. Johnston |
|---|---|
| Тема | Re: Data Type to store Leading Zero(0) |
| Дата | |
| Msg-id | CAKFQuwYWjKAiZjMg38E2DBj8iZFdPncTgJHVJiM6PAGbVxV4Lg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Data Type to store Leading Zero(0) (<soumik.bhattacharjee@kpn.com>) |
| Список | pgsql-admin |
On Wed, Jan 20, 2021 at 4:13 AM <soumik.bhattacharjee@kpn.com> wrote:
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.
A true number stores leading zeros since all bits in the representation are always present regardless of whether they are zero or one. Thus it is a cosmetic presentation choice to suppress displaying those leading zeros, not a storage one.
If these aren't true numbers, i.e., "0001" and "000001" are actually different, then what you have is a string that only uses numbers. Model that using text and let the performance fall where it will.
David J.
В списке pgsql-admin по дате отправления: