Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6CCE0475BC9; Fri, 16 Aug 2002 03:49:06 -0400 (EDT) Received: from mail.distalzou.net (203.141.139.231.user.ad.il24.net [203.141.139.231]) by postgresql.org (Postfix) with ESMTP id 84C07475A05; Fri, 16 Aug 2002 03:49:04 -0400 (EDT) Received: from localhost ([127.0.0.1]) by mail.distalzou.net with esmtp (Exim 3.36 #1) id 17fbql-000CUk-00; Fri, 16 Aug 2002 16:48:51 +0900 Date: Fri, 16 Aug 2002 16:48:49 +0900 (JST) From: Tod McQuillin X-X-Sender: devin@glass.pun-pun.prv To: Bhuvan A Cc: pgsql-sql@postgresql.org, Subject: Re: Casting integer to boolean In-Reply-To: Message-ID: <20020816164529.S5079-100000@glass.pun-pun.prv> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/247 X-Sequence-Number: 9093 On Fri, 16 Aug 2002, Bhuvan A wrote: > How do i cast an integer value to boolean? You can always do something like this: select not count(*) = 0 from my_table; Basically, for any integer i, convert to boolean with: not i = 0 -- Tod McQuillin