Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 31CBA47590C for ; Mon, 4 Nov 2002 02:09:07 -0500 (EST) Received: from www2.tsenekov.com (unknown [64.246.22.23]) by postgresql.org (Postfix) with ESMTP id BB3D24758E1 for ; Mon, 4 Nov 2002 02:09:06 -0500 (EST) Received: from kitezh.hq.taurussoft.org (ppp134-134.dialup.mtu-net.ru [62.118.134.134]) (authenticated (0 bits)) by www2.tsenekov.com (8.11.6/8.11.6) with ESMTP id gA47CvX25548 for ; Mon, 4 Nov 2002 10:12:57 +0300 Received: from flame-in-night.hq.taurussoft.org (flame-in-night.hq.taurussoft.org [192.168.107.1]) by kitezh.hq.taurussoft.org (Postfix) with ESMTP id AA415584C6 for ; Mon, 4 Nov 2002 09:32:32 +0300 (MSK) Received: from localhost (localhost [127.0.0.1]) by flame-in-night.hq.taurussoft.org (Postfix) with ESMTP id EAA7D3F0D2 for ; Mon, 4 Nov 2002 09:33:26 +0300 (MSK) Subject: Re: uniqueidentifier datatype for 7.3.X From: "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?= To: =?koi8-r?Q?=F3=D0=C9=D3=CF=CB_?= =?koi8-r?Q?=D2=C1=D3=D3=D9=CC=CB=C9?= pgsql-sql In-Reply-To: <22619.1036339690@sss.pgh.pa.us> References: <1036317235.29799.34.camel@flame-in-night> <22619.1036339690@sss.pgh.pa.us> Content-Type: text/plain; charset=KOI8-R Content-Transfer-Encoding: quoted-printable X-Mailer: Evolution/1.0 (Preview Release) Date: 04 Nov 2002 09:33:26 +0300 Message-Id: <1036391607.29799.42.camel@flame-in-night> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/41 X-Sequence-Number: 10183 =F7 =F7=D3=CB, 03.11.2002, =D7 19:08, Tom Lane =CE=C1=D0=C9=D3=C1=CC: > "Dmitry G. Mastrukov" =3D?koi8-r?Q?=3DE4=3DCD=3DC9=3DD4=3DD2=3DC9=3DCA_?= =3D =3D?koi8-r?Q?=3DE7=3DC5=3DCE=3DCE=3DC1=3DC4=3DD8=3DC5=3DD7=3DC9=3DDE_?= =3D =3D?koi8-r?Q?=3DED=3DC1=3DD3=3DD4=3DD2=3DC0=3DCB=3DCF=3DD7?=3D writes: > > In this release there is additional function uniqueidentifier_text() > > which converts uniqueidentifier to text datatype. Thanks to Hussein > > Patni! >=20 > 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. >=20 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