Re: Random Number SKU Generator
| От | David G Johnston |
|---|---|
| Тема | Re: Random Number SKU Generator |
| Дата | |
| Msg-id | 1423992178006-5838022.post@n5.nabble.com обсуждение исходный текст |
| Ответ на | Re: Random Number SKU Generator ("Peter Dabrowski" <meritage@mail.com>) |
| Ответы |
Re: Random Number SKU Generator
|
| Список | 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 по дате отправления: