Re: cast of integer to bool doesn't work (anymore?) - Mailing list pgsql-sql

From Achilleus Mantzios
Subject Re: cast of integer to bool doesn't work (anymore?)
Date
Msg-id Pine.LNX.4.44.0303211717480.2751-100000@matrix.gatewaynet.com
Whole thread Raw
In response to Re: cast of integer to bool doesn't work (anymore?)  (Eric Veldhuyzen <ericv@xs4all.net>)
List pgsql-sql
On Fri, 21 Mar 2003, Eric Veldhuyzen wrote:

> On Fri, Mar 21, 2003 at 04:46:17PM -0200, Achilleus Mantzios wrote:
> > 
> > Currently (7.3) all input can be handled if fed as text.
> > So what you can do is simply:
> > 
> >  my $sth = $dbh->prepare(
> >      "INSERT INTO object_def (name, meant_as_subobject) VALUES (?,?)");
> >  $sth->execute('test', '0');
> 
> Ah, thanks, that seems to work, with only minor modifications to our
> code. Is there any reason why integers are no longer convertable to
> booleans?

There has been some general rectification on the casting system in 7.3.*.

> 
> 

-- 
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-210-8981112
fax:    +30-210-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: cast of integer to bool doesn't work (anymore?)
Next
From:
Date:
Subject: Re: explain