X-Original-To: pgsql-sql@postgresql.org Received: from opium.xs4all.nl (opium.xs4all.nl [194.109.0.61]) by postgresql.org (Postfix) with ESMTP id 96A43474E4F for ; Fri, 21 Mar 2003 10:01:37 -0500 (EST) Received: from opium.xs4all.nl (eric@localhost [127.0.0.1]) by opium.xs4all.nl (8.12.8/8.12.8/Debian-2) with ESMTP id h2LF1ceQ016987 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Fri, 21 Mar 2003 16:01:38 +0100 Received: (from eric@localhost) by opium.xs4all.nl (8.12.8/8.12.8/Debian-2) id h2LF1c1N016986; Fri, 21 Mar 2003 16:01:38 +0100 Date: Fri, 21 Mar 2003 16:01:38 +0100 From: Eric Veldhuyzen To: Achilleus Mantzios Cc: Eric Veldhuyzen , pgsql-sql@postgresql.org Subject: Re: cast of integer to bool doesn't work (anymore?) Message-ID: <20030321150138.GE6540@opium.xs4all.nl> References: <20030321141940.GD6540@opium.xs4all.nl> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="/3yNEOqWowh/8j+e" Content-Disposition: inline In-Reply-To: X-Virus: Hi! I am a header virus! Copy me into yours and join the fun! X-Files: The truth is out there X-Spam: Fight Spam! Join EuroCAUCE: http://www.euro.cauce.org/ X-Warning: May contain traces of nuts X-message-flag: *** MICROSOFT OUTLOOK FATAL ERROR 15: PRESS ALT+F4 TO CONTINUE User-Agent: Mutt/1.5.3i X-Archive-Number: 200303/500 X-Sequence-Number: 12539 --/3yNEOqWowh/8j+e Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Mar 21, 2003 at 04:46:17PM -0200, Achilleus Mantzios wrote: >=20 > Currently (7.3) all input can be handled if fed as text. > So what you can do is simply: >=20 > my $sth =3D $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? --=20 Eric Veldhuyzen xs4all NSA team --/3yNEOqWowh/8j+e Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+eylSB/Bwnz56kZERAuRuAJ4lyq1lUTKNh/RXAjrBHGuKpVz8mACeOi+U LRDi61++Q9/XPCuiCZs8JU4= =YwVI -----END PGP SIGNATURE----- --/3yNEOqWowh/8j+e--