Postgres Pro
Downloads
Home   >   mailing lists

SQL Syntax - like FIELD and BITPATTERN = BITPATTERN? - Mailing list pgsql-general

From Ozz Nixon
Subject SQL Syntax - like FIELD and BITPATTERN = BITPATTERN?
Date
Msg-id 052C48EA-DE99-4395-8DF7-D2787033ADA2@gmail.com
Whole thread Raw
Responses Re: [SOLVED] SQL Syntax - like FIELD and BITPATTERN = BITPATTERN?  (Ozz Nixon <ozznixon@gmail.com>)
Re: SQL Syntax - like FIELD and BITPATTERN = BITPATTERN?  ("Harvey, Allan AC" <HarveyA@OneSteel.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: disable triggers isolated to transaction only?
Next
From: Ozz Nixon
Date:
Subject: Re: [SOLVED] SQL Syntax - like FIELD and BITPATTERN = BITPATTERN?