zerofill: lost my leading zeroes

From: Vincent Stoessel <vincent(at)xaymaca(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: zerofill: lost my leading zeroes
Date: 2002-03-20 18:41:46
Message-ID: 3C98D7EA.9090903@xaymaca.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2002-03-20 18:48:08 Re: bug/feature with upper function?
Previous Message PG Explorer 2002-03-20 18:27:34 Re: windows client for postgres?