Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6764A47590C for ; Sun, 3 Nov 2002 11:08:14 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id C460A4758DC for ; Sun, 3 Nov 2002 11:08:13 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id gA3G8BhR022620; Sun, 3 Nov 2002 11:08:11 -0500 (EST) To: "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?= Cc: pgsql-sql , Hussein Patni Subject: Re: uniqueidentifier datatype for 7.3.X In-reply-to: <1036317235.29799.34.camel@flame-in-night> References: <1036317235.29799.34.camel@flame-in-night> Comments: In-reply-to "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?= message dated "03 Nov 2002 12:53:54 +0300" Date: Sun, 03 Nov 2002 11:08:10 -0500 Message-ID: <22619.1036339690@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/39 X-Sequence-Number: 10181 "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?= 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