Home > mailing lists

phone number list - Mailing list pgsql-novice

From	Bryan Irvine
Subject	phone number list
Date	September 10, 2003 17:06:59
Msg-id	1063208122.32206.5.camel@elvis Whole thread Raw
Responses	Re: phone number list Re: phone number list Re: phone number list
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: Stephan Szabo
Date: 10 September 2003, 16:09:10
Subject: Re: Which files belong to which database?

From: Bryan Irvine
Date: 10 September 2003, 17:14:57
Subject: how many records

phone number list - Mailing list pgsql-novice

Previous

Next