X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 57573D1B18A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 21 May 2004 12:05:51 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 98983-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 21 May 2004 12:05:31 -0300 (ADT)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 9211CD1B238
	for <pgsql-sql@postgresql.org>; Fri, 21 May 2004 12:05:30 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i4LF5SQ2003688;
	Fri, 21 May 2004 11:05:28 -0400 (EDT)
To: Charlie Clark <charlie@begeistert.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problem with JOINS 
In-reply-to: <20040521092834.1149.5@wonderland.1085121408.fake> 
References: <20040521092834.1149.5@wonderland.1085121408.fake>
Comments: In-reply-to Charlie Clark <charlie@begeistert.org>
	message dated "Fri, 21 May 2004 09:28:34 +0200"
Date: Fri, 21 May 2004 11:05:28 -0400
Message-ID: <3687.1085151928@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200405/198
X-Sequence-Number: 17912

Charlie Clark <charlie@begeistert.org> writes:
> WHERE true
> AND
> person.id_status = 2
> AND
> person.id_authorise = 2
> AND
> ltrim(lower(address.ort)) like lower('Neuss%')
> AND
> bs.value = 'bezahlt' OR bs.value = 'erlassen'
> AND
> users.roles like '%Premium'

AND binds more tightly than OR --- I suspect you wanted some
parentheses.

AND
(bs.value = 'bezahlt' OR bs.value = 'erlassen')
AND

Or you could express the same thing using IN:

AND
bs.value IN ('bezahlt', 'erlassen')
AND

			regards, tom lane