Re: Why is this a cross join?

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: Alban Hertroys <haramrae(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why is this a cross join?
Date: 2013-02-17 20:58:31
Message-ID: CAGuHJrMW0DJmxa-cFwVuzAVrBMDaa86eGieZwJPXYntV8L9uuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Apparently the first 6 characters of those fields are quite common, which
> gives you a result for every possible combination of the same 6-character
> value.

Mmmmm. That seems kind of weird. Is there any way to NOT have this
be a cross join? For example if I extracted the first six characters
into a field and then joined on them it would not be a cross join
right?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Theodore 2013-02-17 21:26:24 Re: Why is this a cross join?
Previous Message Satoshi Nagayasu 2013-02-17 16:42:56 Re: Visual query builder for PosgreSQL?