X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0E3E2D1B478 for ; Tue, 27 Apr 2004 09:47:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 68950-04 for ; Tue, 27 Apr 2004 09:47:48 -0300 (ADT) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id D406FD1B432 for ; Tue, 27 Apr 2004 09:47:43 -0300 (ADT) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id i3RBpsFr026684; Tue, 27 Apr 2004 14:51:54 +0300 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id i3RBpsPv026680; Tue, 27 Apr 2004 14:51:54 +0300 Date: Tue, 27 Apr 2004 14:51:54 +0300 (EEST) From: Achilleus Mantzios To: kumar Cc: pgsql Subject: Re: How to get binary value for an Integer In-Reply-To: <01d701c42c52$d057c550$7502a8c0@hdsc.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/300 X-Sequence-Number: 17675 O kyrios kumar egrapse stis Apr 27, 2004 : > Dear Friends, > > I am using postgres 7.3.2. I wanna get the binary value of number 65536. Is there anyway to get that postgres functions. SELECT 65536::bit(32); (assuming you have in mind a 32 bit arch). > > Thanks > kumar > -- -Achilleus