Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I use the Binary AND operator in a select? - Mailing list pgsql-novice

From Tom Lane
Subject Re: How do I use the Binary AND operator in a select?
Date
Msg-id 15659.1033503550@sss.pgh.pa.us
Whole thread Raw
In response to How do I use the Binary AND operator in a select?  ("Chris Pizzo" <chris@artinside.com>)
List pgsql-novice
Tree view 
"Chris Pizzo" <chris@artinside.com> writes:
> select * from new_tabl where ((col & 64) != 0);

> ERROR:  Unable to identify an operator '&' for types 'int4' and 'int4'

Er ... how old is your Postgres?  Integer & has been there since 7.1
AFAICT ...

            regards, tom lane

pgsql-novice by date:

Previous
From: "Chris Pizzo"
Date:
Subject: How do I use the Binary AND operator in a select?
Next
From: Bruno Wolff III
Date:
Subject: Re: Index use for case insensitive query