Re: Bitmask trickiness - Mailing list pgsql-general

Howard Rogers wrote:
> insert into coloursample values (2,10,'Yellow and Orange');
>
> But how do I find records which are ONLY yellow and orange
what about

select * from coloursample where colour = 10;

regards,
Yeb Havinga