phone number list

Bryan Irvine <bryan.irvine@kingcountyjournal.com>

From: Bryan Irvine <bryan.irvine@kingcountyjournal.com>
To: pgsql-novice@postgresql.org
Date: 2003-09-10T15:35:22Z
Lists: pgsql-novice
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