Data Type to store Leading Zero(0)

Поиск
Список
Период
Сортировка
От
Тема Data Type to store Leading Zero(0)
Дата
Msg-id c77968e8e35a4e9d8f68c2683ae1b807@kpn.com
обсуждение исходный текст
Ответы Re: Data Type to store Leading Zero(0)  (Nidhi Gupta <nidhig631@gmail.com>)
Re: Data Type to store Leading Zero(0)  (Thomas Kellerer <shammat@gmx.net>)
Re: Data Type to store Leading Zero(0)  ("David G. Johnston" <david.g.johnston@gmail.com>)
RE: Data Type to store Leading Zero(0)  ("Michel SALAIS" <msalais@msym.fr>)
Список 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

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: "William Sescu (Suva)"
Дата:
Сообщение: 3 Parameters in pg_settings in CamelCase
Следующее
От: Nidhi Gupta
Дата:
Сообщение: Re: Data Type to store Leading Zero(0)