Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA94077 for ; Sun, 13 Feb 2000 01:36:45 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id BAA02520; Sun, 13 Feb 2000 01:36:10 -0500 (EST) To: "tjk@tksoft.com" cc: phil@Stimpy.netroedge.com, pgsql-sql@hub.org Subject: Re: [SQL] Type casting bool? In-reply-to: <200002130031.QAA16446@uno.tksoft.com> References: <200002130031.QAA16446@uno.tksoft.com> Comments: In-reply-to "tjk@tksoft.com" message dated "Sat, 12 Feb 2000 16:31:25 -0800" Date: Sun, 13 Feb 2000 01:36:09 -0500 Message-ID: <2517.950423769@sss.pgh.pa.us> From: Tom Lane A number of people have suggested that there should be an int4(bool) conversion function, but no one's got round to actually writing it. Presumably the behavior ought to be false => 0 true => 1 NULL => NULL regards, tom lane