From: Kevin Brannen <kevinb@nurseamerica.net>
To: pgsql-sql@postgresql.org
Subject: datatype matrix (was: Re: Sorry..)
Date: Tue, 16 Jul 2002 12:37:04 -0500
Message-ID: <3D3459C0.20209@nurseamerica.net> (raw)
References: <GNELIHDDFBOCMGBFGEFOAECDCDAA.chriskl@familyhealth.com.au>
<7344.1026703661@sss.pgh.pa.us>
<200207151401.38968.josh@agliodbs.com>
Josh Berkus wrote:
> Christopher,
>
>
>>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.
>
>
> I'd suggest making the explicit cast of numeric to text be the exact
> equivalent of:
>
> SELECT btrim(to_char(numeric, '999,999,999,999.9999999999'))
> or similar.
>
In this vain, is there someplace in the docs that has a type conversion
table (matrix) that shows what datatype can be cast into what other
datatype (both implicitly and explicitly)? I haven't seen one and it
would be helpful for us newbies.
Thanks!
Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: kevinb@nurseamerica.net
Subject: Re: datatype matrix (was: Re: Sorry..)
In-Reply-To: <3D3459C0.20209@nurseamerica.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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