Return-Path: Delivered-To: apmail-db-torque-dev-archive@www.apache.org Received: (qmail 56873 invoked from network); 18 Nov 2004 19:17:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 18 Nov 2004 19:17:05 -0000 Received: (qmail 42766 invoked by uid 500); 18 Nov 2004 19:17:03 -0000 Delivered-To: apmail-db-torque-dev-archive@db.apache.org Received: (qmail 42741 invoked by uid 500); 18 Nov 2004 19:17:03 -0000 Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Developers List" Reply-To: "Apache Torque Developers List" Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 42720 invoked by uid 99); 18 Nov 2004 19:17:03 -0000 X-ASF-Spam-Status: No, hits=1.8 required=10.0 tests=FORGED_RCVD_HELO,RCVD_IN_BL_SPAMCOP_NET X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from [212.67.96.160] (HELO msgdirector4.onetel.net.uk) (212.67.96.160) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 18 Nov 2004 11:17:01 -0800 Received: from bolek.coachhouse (213-78-105-159.friaco.onetel.net.uk [213.78.105.159]) by msgdirector4.onetel.net.uk (MOS 3.4.6-GR) with ESMTP id CLO24888; Thu, 18 Nov 2004 18:53:24 GMT Received: (Exim 3.36) #1 (Debian)) protocol: esmtp id 1CUqtd-0000rn-00 ; Thu, 18 Nov 2004 18:20:41 +0000 Message-ID: <419CE7F9.9040104@numerixtechnology.de> Date: Thu, 18 Nov 2004 18:20:41 +0000 From: T E Schmitz Reply-To: mailreg@numerixtechnology.de User-Agent: Mozilla Thunderbird 0.7 (Windows/20040616) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Apache Torque Developers List Subject: issue TRQS221 (invalid SQL for PostgreSQL bool columns) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hello, I apalogize in advance for writing to the dev list about this - I somehow couldn't find how to add a comment to the issue. I had a brief look at v 3.1.1 and noticed that DBPostgres.getBooleanString() still returns "0"/"1" rather than "FALSE"/"TRUE". What puzzles me is: don't the other PostgreSQL users have the same problem as me?! (Henning, you are using psql too, aren't you?) WHERE boolCol = 0 produces the following error on PostgreSQL 7.4 [on Debian]: ERROR: operator does not exist: boolean = integer -- Regards/Gru�, Tarlika Elisabeth Schmitz --------------------------------------------------------------------- To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org For additional commands, e-mail: torque-dev-help@db.apache.org