phone number list

From: Bryan Irvine <bryan(dot)irvine(at)kingcountyjournal(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: phone number list
Date: 2003-09-10 15:35:22
Message-ID: 1063208122.32206.5.camel@elvis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message ghaverla 2003-09-10 17:17:07 Re: phone number list
Previous Message Bryan Irvine 2003-09-10 15:24:06 how many records