Re: Data Type to store Leading Zero(0) - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Data Type to store Leading Zero(0)
Date
Msg-id CAKFQuwbhqfARkOUc5oM1p+Czr1pb8YO=KximuScf3ged7LS7xw@mail.gmail.com
Whole thread Raw
In response to RE: Data Type to store Leading Zero(0)  (<soumik.bhattacharjee@kpn.com>)
List pgsql-admin
On Thu, Apr 15, 2021 at 6:47 AM <soumik.bhattacharjee@kpn.com> wrote:
  • Boolean is not possible as this is phone number.

Phone numbers, despite the word "number" in the name, aren't numbers.  Use text for them.  Or, in the off chance you truly find the performance hit to be unacceptable (I doubt this to be the case) use a made-up integer-like identifier as the PK but then store the actual phone number as a second text field.

David J.

pgsql-admin by date:

Previous
From:
Date:
Subject: RE: Data Type to store Leading Zero(0)
Next
From: Laurenz Albe
Date:
Subject: Re: Data Type to store Leading Zero(0)