Re: Leading Zeros

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: Raw Message | Whole Thread | 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

In response to

Responses

Browse pgsql-novice by date

  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