Re: Data Type to store Leading Zero(0)

> Boolean is not possible as this is phone number.

related2. for inspiration:

*"A (partially implemented!) PostgreSQL extension that provides access to
Google's libphonenumber"*
https://github.com/blm768/pg-libphonenumber * "This extension is in an
alpha state." *
some special characters ( *,# ) not implemented:
https://github.com/blm768/pg-libphonenumber/issues/5

Imre

Imre Samu <pella(dot)samu(at)gmail(dot)com> ezt írta (időpont: 2021. ápr. 16., P,
15:00):

> > Boolean is not possible as this is phone number.
>
> related:
> https://github.com/google/libphonenumber/blob/master/FALSEHOODS.md
>
> *"Phone numbers contain only digits*
> *In Israel, certain advertising numbers start with a *. In New Zealand,
> non-urgent traffic incidents can be reported by calling *555 from a mobile
> phone. Alpha characters may also be used in phone numbers, such as in
> 1-800-Flowers."*
>
>
>
>
> *Phone numbers are numbersNever try to store phone numbers as an int or
> any other kind of numeric data type. You can't do arithmetic on them, and
> while 007, 07 and 7 are the same number they are not necessarily the same
> phone number - in some countries a leading 0 is significant and forms part
> of the number itself (see A leading zero in numbers formatted for domestic
> usage can always be discarded when dialing from abroad). Moreover, a phone
> number may contain other diallable characters (see Phone numbers contain
> only digits) or an extension portion, dialled after waiting for a tone.Tip:
> Use the library to parse and format numbers to handle this correctly for
> every country.*
> *"""*
>
> <soumik(dot)bhattacharjee(at)kpn(dot)com> ezt írta (időpont: 2021. ápr. 15., Cs,
> 15:47):
>
>> Thanks for your mail.
>>
>>
>>
>> - 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(at)gmail(dot)com>
>> *Sent:* woensdag 20 januari 2021 12:20
>> *To:* Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com>
>> *Cc:* pgsql-admin(at)postgresql(dot)org
>> *Subject:* Re: Data Type to store Leading Zero(0)
>>
>>
>>
>> Use datatype smallint(1) for storing zero or use Boolean datatype.
>>
>>
>>
>> On Wed, Jan 20, 2021, 4:43 PM <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:
>>
>> 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
>>
>>
>>
>>