Figured it out:
./sql -S=10.1.10.232
PostgreSQL v8.x Compatible SQL Command Line Tool by 3F, LLC (www.3flabs.com
)
SQL> select * from bffcomwiki where flags & 8 != 0;
pagename
=
=
=
=
=
=
========================================================================
Welcome
1 records found in 3.00 ms.
SQL>
On Mar 2, 2010, at 8:30 PM, Ozz Nixon wrote:
> I do not know how to really describe this...
>
> In pascal I would do
>
> If (AField and Flag3)=Flag3 then ...
>
> Checking to see if AField contains the BIT(s) FLAG3 is set to... is
> there a way to do this in a SELECT statement -- select * from ATable
> where AField and 0x0004=0x0004
>
> ?
>
> Thanks,
> O.