> 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 ibphoenix.com there's a guid generator UDF around there
somewhere
Alan