Make the fields varchar, rather than numeric.
-Louise
-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Bryan Irvine
Sent: Wednesday, September 10, 2003 9:35 AM
To: pgsql-novice@postgresql.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?
http://www.postgresql.org/docs/faqs/FAQ.html