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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Make the fields varchar, rather than numeric.
-Louise
-----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.
so
425 555 0212
ends up being
425 555 212. How can I fix this?
--Bryan
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
From | Date | Subject | |
---|---|---|---|
Next Message | Louise Cofield | 2003-09-10 17:27:27 | Re: how many records |
Previous Message | Simon Willison | 2003-09-10 17:26:30 | Re: how many records |