X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id E609CD1B9CE for ; Tue, 19 Aug 2003 10:10:09 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 53834-02 for ; Tue, 19 Aug 2003 10:10:02 -0300 (ADT) Received: from shop.sme.sk (episoftware.casablanca.sk [81.0.210.150]) by svr1.postgresql.org (Postfix) with ESMTP id 8BF52D1B9B4 for ; Tue, 19 Aug 2003 10:09:58 -0300 (ADT) Received: from [212.55.253.49] (helo=juice) by shop.sme.sk with asmtp (Exim 3.35 #1 (Debian)) id 19p6CS-0001Iv-00 for ; Tue, 19 Aug 2003 15:07:00 +0200 Received: from [10.0.0.25] ([10.0.0.25]) by juice for pgsql-sql@postgresql.org; Tue, 19 Aug 2003 15:09:49 +0200 Subject: Query problem From: Rado Petrik To: PostgreSQL-mailinglist Content-Type: text/plain Message-Id: <1061298143.14403.37.camel@caj> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 Date: 19 Aug 2003 15:02:24 +0200 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/217 X-Sequence-Number: 14833 Hi, I have table "user". table "user" id bit(dec) bit(bin) ----------------------------- 1 1 1 2 3 11 3 12 1100 and I need query - > SELECT "output" FROM user WHERE id = 1 OR id = 2 or id = 3 output = (1111) In programing language output = id(1..3) { $output = ( bit | $output ); } How write query ? . Thanks -- Rado Petrik