| Lists: | pgsql-announcepgsql-sql |
|---|
| From: | "Dmitry G(dot) Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry(at)taurussoft(dot)org> |
|---|---|
| To: | psql-announce mailing list <pgsql-announce(at)postgresql(dot)org>, Список рассылки pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Cc: | Hussein Patni <hussein(dot)patni(at)cosbit(dot)com> |
| Subject: | uniqueidentifier datatype for 7.3.X |
| Date: | 2002-11-03 09:53:54 |
| Message-ID: | 1036317235.29799.34.camel@flame-in-night |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-announce pgsql-sql |
Hi All!
I've ported uniqueidentifier datatype to upcoming PostgreSQL 7.3. It's
available at
http://www.taurussoft.org/files/uniqueidentifier-0.1.9.3.tar.gz
In this release there is additional function uniqueidentifier_text()
which converts uniqueidentifier to text datatype. Thanks to Hussein
Patni!
Version for 7.2.X is available at
http://www.taurussoft.org/files/uniqueidentifier-0.1.9.2.tar.gz
Version for 7.1.X is available at
http://www.taurussoft.org/files/uniqueidentifier-0.1.9.1.tar.gz
The only difference between two releases is adoptation to 7.2.X system
catalog. No new functions/bugfixes.
Uniqueidentifier datatype is 128-bit (16 byte) wide datatype claims to
be unique across Universe. It's a good choice for primary indexes and
making relations between tables.
This inplementation depends on libuuid library from e2fsprogs package by
Theodore Ts'o.
Licence is LGPL.
Regards,
Dmitry
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Dmitry G(dot) Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry(at)taurussoft(dot)org> |
| Cc: | pgsql-sql <pgsql-sql(at)postgresql(dot)org>, Hussein Patni <hussein(dot)patni(at)cosbit(dot)com> |
| Subject: | Re: uniqueidentifier datatype for 7.3.X |
| Date: | 2002-11-03 16:08:10 |
| Message-ID: | 22619.1036339690@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-announce pgsql-sql |
"Dmitry G. Mastrukov" =?koi8-r?Q?=E4=CD=C9=D4=D2=C9=CA_?= =?koi8-r?Q?=E7=C5=CE=CE=C1=C4=D8=C5=D7=C9=DE_?= =?koi8-r?Q?=ED=C1=D3=D4=D2=C0=CB=CF=D7?= <dmitry(at)taurussoft(dot)org> writes:
> In this release there is additional function uniqueidentifier_text()
> which converts uniqueidentifier to text datatype. Thanks to Hussein
> Patni!
You would be better off to name the conversion function text(uuid)
and declare it as a cast (possibly an explicit-only cast, depending on
whether you think automatic casting of uuid to text is a good idea).
Not following the standard naming convention for conversion functions
just creates an extra memory burden for users.
regards, tom lane
| From: | "Dmitry G(dot) Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry(at)taurussoft(dot)org> |
|---|---|
| To: | Список рассылки pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: uniqueidentifier datatype for 7.3.X |
| Date: | 2002-11-04 06:33:26 |
| Message-ID: | 1036391607.29799.42.camel@flame-in-night |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-announce pgsql-sql |
В Вск, 03.11.2002, в 19:08, Tom Lane написал:
> "Dmitry G. Mastrukov" =?koi8-r?Q?=E4=CD=C9=D4=D2=C9=CA_?= =?koi8-r?Q?=E7=C5=CE=CE=C1=C4=D8=C5=D7=C9=DE_?= =?koi8-r?Q?=ED=C1=D3=D4=D2=C0=CB=CF=D7?= <dmitry(at)taurussoft(dot)org> writes:
> > In this release there is additional function uniqueidentifier_text()
> > which converts uniqueidentifier to text datatype. Thanks to Hussein
> > Patni!
>
> You would be better off to name the conversion function text(uuid)
> and declare it as a cast (possibly an explicit-only cast, depending on
> whether you think automatic casting of uuid to text is a good idea).
> Not following the standard naming convention for conversion functions
> just creates an extra memory burden for users.
>
Thanks, Tom. I thought about it but I should consult with doc how to do
so. Now I simply add Hussein's function to the package because my task
was to port datatype itself.
Regards,
Dmitry