Postgres Pro
Downloads
Home   >   mailing lists

phone number list - Mailing list pgsql-novice

From Bryan Irvine
Subject phone number list
Date
Msg-id 1063208122.32206.5.camel@elvis
Whole thread Raw
Responses Re: phone number list  (<ghaverla@freenet.edmonton.ab.ca>)
Re: phone number list  ("Louise Cofield" <lcofield@box-works.com>)
Re: phone number list  (Oliver Elphick <olly@lfix.co.uk>)
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:

Previous
From: Stephan Szabo
Date:
Subject: Re: Which files belong to which database?
Next
From: Bryan Irvine
Date:
Subject: how many records