Subject RE: [firebird-support] GUID/Random number generation?
Author Alan McDonald
> Hi,
> I have a requirement to create a unique 7 character string
> (numbers and letters). In the file-based implementation, we
> simply extracted the first 7 characters of a GUID. But I see
> no way to obtain a GUID in PSQL. Surely there is a RANDOM
> function? But didn't find a reference to such a beast in
> Helen's Bible.
> BTW- I can't used a Generator because these values are not internal.
> So, is there a free library I can obtain to either generate a
> GUID or a random value?
> cheers
> -randall sell

Have a look at there's a guid generator UDF around there