pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeduniqueidentifier datatype for 7.3.X
3+ messages / 2 participants
[nested] [flat]
* uniqueidentifier datatype for 7.3.X
@ 2002-11-03 09:53 "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry@taurussoft.org>
2002-11-03 16:08 ` Re: uniqueidentifier datatype for 7.3.X Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков @ 2002-11-03 09:53 UTC (permalink / raw)
To: psql-announce mailing list <pgsql-announce@postgresql.org>; pgsql-sql; +Cc: Hussein Patni <hussein.patni@cosbit.com>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: uniqueidentifier datatype for 7.3.X
2002-11-03 09:53 uniqueidentifier datatype for 7.3.X "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry@taurussoft.org>
@ 2002-11-03 16:08 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-11-04 06:33 ` Re: uniqueidentifier datatype for 7.3.X "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry@taurussoft.org>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2002-11-03 16:08 UTC (permalink / raw)
To: "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry@taurussoft.org>; +Cc: pgsql-sql; Hussein Patni <hussein.patni@cosbit.com>
"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@taurussoft.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: uniqueidentifier datatype for 7.3.X
2002-11-03 09:53 uniqueidentifier datatype for 7.3.X "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry@taurussoft.org>
2002-11-03 16:08 ` Re: uniqueidentifier datatype for 7.3.X Tom Lane <tgl@sss.pgh.pa.us>
@ 2002-11-04 06:33 ` "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry@taurussoft.org>
0 siblings, 0 replies; 3+ messages in thread
From: "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков @ 2002-11-04 06:33 UTC (permalink / raw)
To: 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@taurussoft.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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-11-04 06:33 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-03 09:53 uniqueidentifier datatype for 7.3.X "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry@taurussoft.org>
2002-11-03 16:08 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-11-04 06:33 ` "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков <dmitry@taurussoft.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox