Re: Random Number SKU Generator

Yes, I agree with this.
I believe  that Luhn algorithm function got check digit, so if this check digit could be placed in front this could be
achieved.

regards
Peter


Sent: Sunday, February 15, 2015 at 8:22 PM
From: "David G Johnston" <david.g.johnston@gmail.com>
To: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Random Number SKU Generator
Peter Dabrowski wrote
> I found one issue,
> The leading zeros are removed. expected number "00042" printed "42"

My unscientific suggestion is to combine a leading random number between 1
and 9 with the trailing 4 digit (With leading zeros) number so that you
never have the first digit of the SKU be a zero.

Too many technical issues with all numeric strings containing leading zeros;
and I think human ones too.

David J.




--
View this message in context: http://postgresql.nabble.com/Random-Number-SKU-Generator-tp5837824p5838022.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice[http://www.postgresql.org/mailpref/pgsql-novice]