Postgres Pro
Downloads
Home   >   mailing lists

zerofill: lost my leading zeroes - Mailing list pgsql-general

From Vincent Stoessel
Subject zerofill: lost my leading zeroes
Date
Msg-id 3C98D7EA.9090903@xaymaca.com
Whole thread Raw
Responses Re: zerofill: lost my leading zeroes
List pgsql-general
Tree view 
ugh,
I created an integer  column to hold zip codes and
forgot that some US states have zips that start with zeroes.
ie 03455 in new England. There is no zerofill option for
the integer data type is there?
Vincent

pgsql-general by date:

Previous
From: Bradley Brown
Date:
Subject: dbase restore
Next
From: Richard Huxton
Date:
Subject: Re: bug/feature with upper function?