Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id 09549475473
	for <pgsql-sql@postgresql.org>; Sun, 14 Jul 2002 23:27:51 -0400 (EDT)
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 g6F3RfAl007345;
	Sun, 14 Jul 2002 23:27:41 -0400 (EDT)
To: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: Sorry.. 
In-reply-to: <GNELIHDDFBOCMGBFGEFOAECDCDAA.chriskl@familyhealth.com.au> 
References: <GNELIHDDFBOCMGBFGEFOAECDCDAA.chriskl@familyhealth.com.au>
Comments: In-reply-to "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
	message dated "Mon, 15 Jul 2002 11:17:30 +0800"
Date: Sun, 14 Jul 2002 23:27:41 -0400
Message-ID: <7344.1026703661@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200207/208
X-Sequence-Number: 8587

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> [ there's no cast from numeric to text ]

Feel free to contribute one.

In the bad old days when we couldn't distinguish explicit from implicit
cast functions, I was wary of adding new cast pathways.  Too many
implicit casts and you have no type system at all.  But in 7.3 there
should be no reason to object to an explicit-only cast from numeric
to text or vice versa.

			regards, tom lane