Query problem - Mailing list pgsql-sql

From Rado Petrik
Subject Query problem
Date
Msg-id 1061298143.14403.37.camel@caj
Whole thread Raw
Responses Re: Query problem  (Richard Huxton <dev@archonet.com>)
Re: Query problem  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
Hi,  I have table "user".

table "user"

id      bit(dec)    bit(bin) 
-----------------------------1       1             12       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 <r.p@szm.sk>




pgsql-sql by date:

Previous
From: Tim Andersen
Date:
Subject: Re: Migration from db2 to postgres'
Next
From: Tom Lane
Date:
Subject: Re: postgres 7.1.3: why does the query plan ignore indexes?