Skip site navigation (1) Skip section navigation (2)

Re: phone number list

From: "Louise Cofield" <lcofield(at)box-works(dot)com>
To: "'Bryan Irvine'" <bryan(dot)irvine(at)kingcountyjournal(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: phone number list
Date: 2003-09-10 17:26:41
Message-ID: 000b01c377c0$b3556490$7801a8c0@Louise (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Make the fields varchar, rather than numeric.

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Bryan Irvine
Sent: Wednesday, September 10, 2003 9:35 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] phone number list

I have a db that contains phone numbers

The data that get inserted looks like this

425 555 1212

I have a script that inserts that into the DB, the problem is that
sometimes the suffix might start with a 0 and is getting truncated.


425 555 0212 

ends up being

425 555  212.  How can I fix this?


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


In response to

pgsql-novice by date

Next:From: Louise CofieldDate: 2003-09-10 17:27:27
Subject: Re: how many records
Previous:From: Simon WillisonDate: 2003-09-10 17:26:30
Subject: Re: how many records

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group