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  ("Peter Dabrowski" <meritage@mail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Peter Dabrowski"
Дата:
Сообщение: Re: Random Number SKU Generator
Следующее
От: David G Johnston
Дата:
Сообщение: Re: Random Number SKU Generator