From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: sad <sad@bankir.ru>
Cc: Michael Glaesemann <grzm@myrealbox.com>
Cc: Stephan Szabo <sszabo@megazone.bigpanda.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: casting BOOL to somthng
Date: Wed, 01 Sep 2004 10:19:54 -0400
Message-ID: <6204.1094048394@sss.pgh.pa.us> (raw)
In-Reply-To: <200409010859.08037.peter_e@gmx.net>
References: <200408311306.25545.sad@bankir.ru>
<8AF2CE57-FBE1-11D8-A2A0-000A95C88220@myrealbox.com>
<200409010955.45834.sad@bankir.ru>
<200409010859.08037.peter_e@gmx.net>
Peter Eisentraut <peter_e@gmx.net> writes:
> The cast to text, however, is part of the data model, and it has to be
> both natural and universal. I think you agree that there is no
> universal, obvious correspondence between character strings and boolean
> values, at least not nearly as universal and obvious as the well-known
> correspondence between character strings and numbers. We could pick
> one arbitrary correspondence and implement it, and if we did we would
> probably pick one that is consistent with the mapping used by libpq and
> other frontends. But doing that gains no functionality, so why bother?
Actually it does gain functionality, because there are plenty of times
when you need to manipulate a textual representation of a data value.
We have casts to text for many datatypes already:
castsource | castcontext
-----------------------------+-------------
character | i
character varying | i
"char" | i
name | i
bigint | i
smallint | i
integer | i
oid | i
real | i
double precision | i
macaddr | e
cidr | e
inet | e
date | i
time without time zone | i
timestamp without time zone | i
timestamp with time zone | i
interval | i
time with time zone | i
numeric | i
(20 rows)
and I think it is reasonable to say that we should have them for all
types. My only beef with the above table is that most of these casts
should not be implicitly invokable --- I think you should have to write
an explicit CAST.
As for the "which representation" argument, both consistency and
implementation simplicity say that it should be whatever the datatype's
output function delivers. Indeed it's just a historical accident that
Postgres didn't define the datatype output functions as returning "text"
values in the first place.
regards, tom lane
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: tgl@sss.pgh.pa.us, peter_e@gmx.net, sad@bankir.ru, grzm@myrealbox.com, sszabo@megazone.bigpanda.com
Subject: Re: casting BOOL to somthng
In-Reply-To: <6204.1094048394@sss.pgh.pa.us>
* 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