Analogue to SQL Server UniqueIdentifier?
| От | jerry.evans@chordia |
|---|---|
| Тема | Analogue to SQL Server UniqueIdentifier? |
| Дата | |
| Msg-id | 03c101c870b9$3fd1bdb0$0565a8c0@p424 обсуждение исходный текст |
| Ответы |
Re: Analogue to SQL Server UniqueIdentifier?
|
| Список | pgsql-general |
Hi
My porting experiment has encountered the SQL Server UniqueIdentifier problem. I can see one or two suggestions about this have been made over the years but I'd like to try and stay close to the original. So:
I'm wondering if I can use a combination of a domain 'hack' for syntatic compatibillity and an externally implemented function to handle generation.
More specifically, given a table defined thus:
CREATE TABLE jazz(
UUID UniqueIdentifier DEFAULT newIdentifier(),
rootname VARCHAR(255),
data_source VARCHAR(1024),
date_created DATETIME DEFAULT GETDATE())
1. Can I handle the UniqueIdentifier datatype via a domain that aliases UniqueIdentifier to char(X) (for example) ? This seems to work fine for the DATETIME datatype.
2. Implement newIdentifier() in some extension DLL that simply calls CoCreateGUID() ?
or does uuid-ossp do this for me?
Thx.
Jerry.
В списке pgsql-general по дате отправления: