Content-Type: text/plain;
  charset="iso-8859-1"
From: sad <sad@bankir.ru>
Organization: IT
To: Geoffrey <esoteric@3times25.net>, pgsql-sql@postgresql.org
Subject: Re: casting BOOL to somthng
Date: Wed, 1 Sep 2004 08:22:37 +0400
User-Agent: KMail/1.4.3
References: <200408311306.25545.sad@bankir.ru>
	<200408311524.16036.sad@bankir.ru> <41346D6C.30804@3times25.net>
In-Reply-To: <41346D6C.30804@3times25.net>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200409010822.37712.sad@bankir.ru>

On Tuesday 31 August 2004 16:22, Geoffrey wrote:
> sad wrote:
> > you wrote:
> >>you can use CREATE CAST to make your own cast from boolean to text.
> >
> > thnx it helps.
> >
> > and i am still desire to know _WHY_ there are no predefined cast for BO=
OL
> > ? and at the same time there are predefined casts for INT and FLOAT....=
..
>
> I'd like to understand in what context you would find this useful.
> Don't take me wrong please.  I'm by no means a db expert, but I can't
> see a purpose for such a cast.  Can you provide a reasonable example of
> such usage?

Yes i can.=20
look:

CREATE TABLE t (a int, b text, c bool);

SELECT 'the row is: a=3D'||a::TEXT||' b=3D'||b||' c=3D'||c::TEXT FROM t;