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

From Eric Veldhuyzen
Subject Re: cast of integer to bool doesn't work (anymore?)
Date
Msg-id 20030321150138.GE6540@opium.xs4all.nl
Whole thread Raw
In response to Re: cast of integer to bool doesn't work (anymore?)  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: cast of integer to bool doesn't work (anymore?)  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql
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?

--
Eric Veldhuyzen
xs4all NSA team

pgsql-sql by date:

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