On Mon, Jun 30, 2003 at 22:28:15 +1000, Rudi Starcevic <[EMAIL PROTECTED]> wrote: > > Hi, > > I'm learning to use Postgresql's bitwise operator's as I'm interested > in building super fast search's based on user selections in web forms. > > So far so good but I have just lost it a little so I thought I'd post. > Please growl at me if I'm asking on the wrong list :-) > > I understand this: > > SELECT 111 & 11 = 11 > > but not this > > SELECT 1111 & 111 = 71 > > I was expecting the second example to be > > SELECT 1111 & 111 = 111
In the above examples the numbers are decimal values. Maybe you wanted to do something like the following: area=> select b'1111' & b'0111'; ?column? ---------- 0111 (1 row) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
