X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 448029DC84E for ; Tue, 24 Jan 2006 10:59:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17410-06 for ; Tue, 24 Jan 2006 10:59:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id D9D429DC86A for ; Tue, 24 Jan 2006 10:59:04 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k0OEx1Lm018438; Tue, 24 Jan 2006 09:59:01 -0500 (EST) To: Greg Stark cc: "Jesper K. Pedersen" , pgsql-sql@postgresql.org Subject: Re: How to implement Microsoft Access boolean (YESNO) In-reply-to: <87r76yusi3.fsf@stark.xeocode.com> References: <20060122211351.371f20d8@io.solnet> <22008.1137962771@sss.pgh.pa.us> <20060122221328.433038a9@io.solnet> <873bjewts8.fsf@stark.xeocode.com> <8505.1138050132@sss.pgh.pa.us> <87r76yusi3.fsf@stark.xeocode.com> Comments: In-reply-to Greg Stark message dated "24 Jan 2006 00:03:48 -0500" Date: Tue, 24 Jan 2006 09:59:01 -0500 Message-ID: <18437.1138114741@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.096 required=5 tests=[AWL=0.096] X-Spam-Score: 0.096 X-Spam-Level: X-Archive-Number: 200601/153 X-Sequence-Number: 23942 Greg Stark writes: > Is there an implicit cast from ints? So if I pass a 0 or 1 argument for a > boolean parameter now it'll work? That definitely didn't work in the past. 1. There's a cast. 2. It's not implicit. 3. You have always (well, at least since 7.0 which is the oldest version I have alive to check) been able to write '0' or '1' as the input textual representation of bool. The latter has nothing to do with any integer coercion though. regards, tom lane