Re: Leading Zeros - Mailing list pgsql-novice

From
Subject Re: Leading Zeros
Date
Msg-id 20050804035720.68614.qmail@web33303.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Leading Zeros  (Gordon Haverland <ghaverla@shaw.ca>)
Responses Re: Leading Zeros  (David <dbree@duo-county.com>)
Re: Leading Zeros  (Gnanavel S <s.gnanavel@gmail.com>)
List pgsql-novice
--- Gordon Haverland <ghaverla@shaw.ca> wrote:

> 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

Gord,

if i do that, though, i think i'm unable to increment
the number string in php.  the user inputs the
beginning and ending s/n only.  i use php to create
and enter the other s/ns.  can i still increment a
number string using i++?



__________________________________
Yahoo! Mail
Stay connected, organized, and protected. Take the tour:
http://tour.mail.yahoo.com/mailtour.html


pgsql-novice by date:

Previous
From: Gordon Haverland
Date:
Subject: Re: Leading Zeros
Next
From: David
Date:
Subject: Re: Leading Zeros