Re: Why is this a cross join?

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: Kevin Grittner <kgrittn(at)ymail(dot)com>
Cc: Tony Theodore <tony(dot)theodore(at)gmail(dot)com>, Alban Hertroys <haramrae(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why is this a cross join?
Date: 2013-02-18 22:19:35
Message-ID: CAGuHJrOuCH2fDdnC5iFUGV1XzvBFTZQQpdxNJJ+xu4s5A8ou4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> for every row in one of the tables? If so, how do you want to
> determine which of the matching rows in the other table to choose,
> and which to ignore?

In this case it's a simple lookup. Any of the matching rows will do
but I just want one.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Van Dyk 2013-02-18 23:05:05 subselects vs WITH in views
Previous Message René Romero Benavides 2013-02-18 21:01:28 Re: Streaming replication and sharding