pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Eric Veldhuyzen <ericv@xs4all.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: cast of integer to bool doesn't work (anymore?)
Date: Fri, 21 Mar 2003 17:20:01 -0200 (GMT+2)
Message-ID: <Pine.LNX.4.44.0303211717480.2751-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <20030321150138.GE6540@opium.xs4all.nl>

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




view thread (7+ messages)

Message-ID: <Pine.LNX.4.44.0303211717480.2751-100000@matrix.gatewaynet.com>
Permalink:  ../Pine.LNX.4.44.0303211717480.2751-100000@matrix.gatewaynet.com/
Also on:    postgresql.org/message-id/Pine.LNX.4.44.0303211717480.2751-100000@matrix.gatewaynet.com

 · 

reply

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: achill@matrix.gatewaynet.com, ericv@xs4all.net
  Subject: Re: cast of integer to bool doesn't work (anymore?)
  In-Reply-To: <Pine.LNX.4.44.0303211717480.2751-100000@matrix.gatewaynet.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