Re: Queries joining views - Mailing list pgsql-general

From Tom Lane
Subject Re: Queries joining views
Date
Msg-id 2446.1156252906@sss.pgh.pa.us
Whole thread Raw
In response to Re: Queries joining views  (Alban Hertroys <alban@magproductions.nl>)
Responses Re: Queries joining views  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
Alban Hertroys <alban@magproductions.nl> writes:
> However, mm_product.number always matches either mm_insrel.snumber or
> mm_insrel.dnumber (source and destination respectively). The other way
> around this isn't the case; then snumber and dnumber match number-fields
> in other tables (they always do).

Oh, then we are looking at the wrong things: we should be comparing the
histograms of the fields that are being used as the join keys in this
query.  I had thought they were both "number", but I must be confused.

            regards, tom lane

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Queries joining views
Next
From: "Silvela, Jaime \(Exchange\)"
Date:
Subject: Re: could not open relation - why?