From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: sad <sad@bankir.ru>
Cc: Michael Glaesemann <grzm@myrealbox.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: casting BOOL to somthng
Date: Wed, 1 Sep 2004 00:22:26 -0700 (PDT)
Message-ID: <20040901002131.P60523@megazone.bigpanda.com> (raw)
In-Reply-To: <200409011027.11800.sad@bankir.ru>
References: <200408311306.25545.sad@bankir.ru>
<200409010941.54539.sad@bankir.ru>
<20040901001230.O60275@megazone.bigpanda.com>
<200409011027.11800.sad@bankir.ru>
On Wed, 1 Sep 2004, sad wrote:
> > There's a difference between an output function and a cast to text.
> > One gives you an external representation of the data for end use. The
> > other gives you an internal representation for manipulation.
>
> And at the same time
>
> 't'::TEXT can be casted to BOOL
> 't'::BOOL
>
> but reverse.
select 't'::text::bool;
ERROR: cannot cast type text to boolean
If you're thinking 't'::bool, that's something different.
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: sszabo@megazone.bigpanda.com, sad@bankir.ru, grzm@myrealbox.com
Subject: Re: casting BOOL to somthng
In-Reply-To: <20040901002131.P60523@megazone.bigpanda.com>
* 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