| From: | <operationsengineer1(at)yahoo(dot)com> |
|---|---|
| To: | ghaverla(at)shaw(dot)ca, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Leading Zeros |
| Date: | 2005-08-04 03:57:20 |
| Message-ID: | 20050804035720.68614.qmail@web33303.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
--- Gordon Haverland <ghaverla(at)shaw(dot)ca> wrote:
> On Wednesday 03 August 2005 15:23,
> operationsengineer1(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David | 2005-08-04 04:32:18 | Re: Leading Zeros |
| Previous Message | Gordon Haverland | 2005-08-03 21:55:54 | Re: Leading Zeros |