# vmaverick@xxxxxxx / 2006-08-31 07:35:30 -0700: > > Ralf Engelschall's OSSP uuid looks very good. Written in C with > > interfaces into PostgreSQL, PHP and C++ (classes wrapping the C > > structures and functions). > > > > http://www.ossp.org/pkg/lib/uuid/ > > Can you give a link to the PostgreSQL binding? I haven't been able to > find it there. All I see is C, Perl and PHP bindings for the generation > of UUIDs, and nothing about storage. The above page links to the source repository [1] which in turn contains a "pgsql" directory[2]. [1] http://cvs.ossp.org/dir?d=ossp-pkg/uuid [2] http://cvs.ossp.org/dir?d=ossp-pkg/uuid/pgsql > > CREATE TABLE t (id UUID DEFAULT 'uuid(4)' PRIMARY KEY); > (For my application, as it happens, I don't need to generate UUIDs in > the database, but I recognize that would be useful.) Actually, serverside generation of uuids is the least interesting aspect of that snippet. Use of custom types in indexes requires appropriate operator classes, and I was trying to give a hint that the library's support for PostgreSQL is quite comprehensive. Now, an operator class is no rocket science, but the ability to use the type in any way without having to add missing features is nice anyway. -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991
