Re: Missing numbers

From: Harald Fuchs <use_reply_to(at)protecting(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Missing numbers
Date: 2005-06-01 11:00:43
Message-ID: pu4qcifijo.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <1117618428(dot)3844(dot)914(dot)camel(at)localhost(dot)localdomain>,
Simon Riggs <simon(at)2ndquadrant(dot)com> writes:

> If the WHERE clause said bdocs.doc_numero > 7 we would hope that this
> was applied before the join.

Stating this would change the OUTER into an INNER JOIN, and this would
imply that the order of the restrictions is irrelevant - for the
result set both conditions must be satisfied.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-06-01 12:42:11 Re: PostgreSQL release schedule
Previous Message Simon Riggs 2005-06-01 09:33:48 Re: Missing numbers