Re: Leading Zeros - Mailing list pgsql-novice

From Gordon Haverland
Subject Re: Leading Zeros
Date
Msg-id 200508031555.55920.ghaverla@shaw.ca
Whole thread Raw
In response to Leading Zeros  (<operationsengineer1@yahoo.com>)
Responses Re: Leading Zeros  (<operationsengineer1@yahoo.com>)
List pgsql-novice
On Wednesday 03 August 2005 15:23, operationsengineer1@yahoo.com
wrote:
> can i use pgsql to force th einput of leading zeros?
>
> i have an application that enters serial numbers
> within a range, eg, 00001 to 00003.

Use a string type, but only allow certain characters.

Gord

pgsql-novice by date:

Previous
From:
Date:
Subject: Leading Zeros
Next
From:
Date:
Subject: Re: Leading Zeros