Re: uniqueidentifier datatype for 7.3.X

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
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

In response to


Browse pgsql-announce by date

  From Date Subject
Next Message Justin Clift 2002-11-04 02:16:23 Spanish version of the PostgreSQL "Advocacy and Marketing" site is ready
Previous Message Dmitry G. Mastrukov Дмитрий Геннадьевич Мастрюков 2002-11-03 09:53:54 uniqueidentifier datatype for 7.3.X

Browse pgsql-sql by date

  From Date Subject
Next Message pilsl 2002-11-04 00:11:06 Re: 7.2.3: tuple is too big (max 8136)
Previous Message Alexander M. Pravking 2002-11-03 12:19:32 Re: Different size in the DATA directory