Re: How do I use the Binary AND operator in a select?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Pizzo" <chris(at)artinside(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How do I use the Binary AND operator in a select?
Date: 2002-10-01 20:19:10
Message-ID: 15659.1033503550@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Chris Pizzo" <chris(at)artinside(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2002-10-01 21:05:50 Re: Index use for case insensitive query
Previous Message eric soroos 2002-10-01 18:48:29 Index use for case insensitive query