On Wed, 8 Feb 2006, Jacob Costello wrote:
> Postgres doesn't seem to optimize away unnecessary joins in a view
> definition when the view is queried in such a way that the join need not
> be executed. In the example below, I define two tables, foo and bar,
> with a foreign key on bar referencing
Jacob Costello <[EMAIL PROTECTED]> writes:
> Postgres doesn't seem to optimize away unnecessary joins
There is no such thing as an unnecessary join, unless you are willing to
stake the correctness of the query on constraints that could be dropped
after the query is planned. Until we have some inf
