On 7/20/2010 11:59 PM, Howard Rogers wrote:
But how do I find records which are ONLY yellow and orange, and exclude records which have some other colour mixed in, in one simple query without a lot of 'not this, not that' additions, and without using multiple separate AND tests to nail it down? ... I suspect the answer is really simple... but I'm having writer's block today! All help appreciated.
Just use a regular ol' equals. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general