Re: Random Number SKU Generator - Mailing list pgsql-novice

From David G Johnston
Subject Re: Random Number SKU Generator
Date
Msg-id 1423992178006-5838022.post@n5.nabble.com
Whole thread Raw
In response to Re: Random Number SKU Generator  ("Peter Dabrowski" <meritage@mail.com>)
Responses Re: Random Number SKU Generator  ("Peter Dabrowski" <meritage@mail.com>)
List pgsql-novice
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.


pgsql-novice by date:

Previous
From: "Peter Dabrowski"
Date:
Subject: Re: Random Number SKU Generator
Next
From: David G Johnston
Date:
Subject: Re: Random Number SKU Generator