Re: Missing numbers - Mailing list pgsql-general

From Harald Fuchs
Subject Re: Missing numbers
Date
Msg-id pu4qcifijo.fsf@srv.protecting.net
Whole thread Raw
In response to Missing numbers  (josue <josue@lamundial.hn>)
List pgsql-general
In article <1117618428.3844.914.camel@localhost.localdomain>,
Simon Riggs <simon@2ndquadrant.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.

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Missing numbers
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL release schedule