Sunday, November 18, 2007

RE: [firebird-support] GUID/Random number generation?

> 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

__._,_.___
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Recent Activity
Visit Your Group
Yahoo! Groups

Endurance Zone

A Yahoo! Group

for better endurance.

Best of Y! Groups

Check it out

and nominate your

group to be featured.

Need traffic?

Drive customers

With search ads

on Yahoo!

.

__,_._,___

No comments: