Re: Bitmask trickiness

From: Yeb Havinga <yebhavinga(at)gmail(dot)com>
To: Howard Rogers <hjr(at)diznix(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Bitmask trickiness
Date: 2010-07-21 08:26:54
Message-ID: 4C46AF4E.6080403@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-07-21 08:38:16 Re: INSERT RETURNING and partitioning
Previous Message Jan Otto 2010-07-21 08:17:28 Re: INSERT RETURNING and partitioning