Random Number SKU Generator

I use a Luhn algorithm to generete random number, inserted below sql code to column 'SKU"

 

ALTER TABLE m_product ALTER sku SET DEFAULT ltrim(to_char(luhn_generate(round(random()*10000)::int), '00000'))

 

as a result on record saving random number is generated, but my problem is the numbers are not unique.

 

Somone sugest that I  should write a function to encapsulate "ltrim(to_char(luhn_generate(

round(random()*10000)::int), '00000'))"  and at the same time, check if the value is already used in
thetable. 

 

in pseudo code it would look something like this:

 

generateMProductSKU(){
    skuGen=""
    needToGenerate = true
    while(needToGenerate){
      skuGen = ltrim(to_char(luhn_generate(round(random()*10000)::int), '00000'))
      if((Select count(*) from M_Product where sku =skuGen) = 0
         needToGenerate =  false
   }
   return skuGen
}

 

Culd somebody help me tu structure code into right sql format so it could be inserted into database.

 

Thank you very much.

Peter