From: Bruno Wolff III <bruno@wolff.to>
To: KÖPFERL Robert <robert.koepferl@sonorys.at>
Cc: Sql-Postgre <pgsql-sql@postgresql.org>
Subject: Re: Converting varchar to bool
Date: Wed, 15 Jun 2005 09:31:24 -0500
Message-ID: <20050615143124.GC7595@wolff.to> (raw)
In-Reply-To: <ED4E30DD9C43D5118DFB00508BBBA76EB1676C@neptun.sonorys.at>
References: <ED4E30DD9C43D5118DFB00508BBBA76EB1676C@neptun.sonorys.at>
On Wed, Jun 15, 2005 at 14:14:46 +0200,
KÖPFERL Robert <robert.koepferl@sonorys.at> wrote:
> Hi,
>
>
> I have currently trouble working with boolean values and variables in
> functions.
>
> As one would expect, a
> select '1'::bool, 't'::bool, 'true'::unknown::boolean
>
> works.
>
> As a select '1' tells us this seems as a conversion unknown->bool
> or ??maybe?? a boolean literal??
No it is not a conversion, '1', 't' and 'true' are all valid boolean
strings representing TRUE. The input is not being converted from text
to boolean.
>
> what-o-ever, at least my function gets not accepted:
>
>
> CREATE OR REPLACE FUNCTION testbool(varchar)
> RETURNS boolean AS
> $BODY$
> SELECT $1::boolean
> $BODY$
> LANGUAGE 'sql' STABLE STRICT SECURITY DEFINER;
>
> Postgres complains that it can't convert varchar to boolean.
> Actually neither $1::unknown::bool works.
> It turns out that there exists no conversion varchar/text/unknown ->
> boolean.
> Actually there's not any conversion -> boolean.
>
> How should this be treaten?
> *being confused*
>
>
> sorry for duplicating (I'm sure) this topic, at least I tried to find it in
> the listarcive.
It has been discussed in the last week.
test.sql:
CREATE OR REPLACE FUNCTION testbool(varchar)
RETURNS boolean AS
$BODY$
SELECT boolin(textout($1));
$BODY$
LANGUAGE 'sql' STABLE STRICT SECURITY DEFINER;
SELECT testbool('true');
bruno=> \i test.sql
CREATE FUNCTION
testbool
----------
t
(1 row)
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: bruno@wolff.to, robert.koepferl@sonorys.at
Subject: Re: Converting varchar to bool
In-Reply-To: <20050615143124.GC7595@wolff.to>
* 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