From: Jamie Lawrence <postgres@jal.org>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Fwd: Bad Join moment - how is this happening?
Date: Fri, 1 Aug 2003 12:02:42 -0500
Message-ID: <20030801170242.GG1073@jal.clueinc.net> (raw)
In-Reply-To: <200307302036.22095.dev@archonet.com>
References: <20030730200732.GW1073@jal.clueinc.net>
<200307302036.22095.dev@archonet.com>
Sorry to be slow on responses... Thanks to everyone who replies.
On Wed, 30 Jul 2003, Richard Huxton wrote:
> On Wednesday 30 July 2003 21:07, Jamie Lawrence wrote:
> > I fully admit that I've been staring at this too long, and simply don't
> > understand what is wrong. Apologies aside, any kind sql hackers who care
> > to look this over will earn my undying gratitude, and a beer in the bar
> > of your choice, should we ever meet.
>
> I'll take that beer (assuming I'm right)
I think you nailed it first. You appear to be in London, which I haven't
made it to in ~15 years, and mailing it is probably a bad idea. Ever
make it to the NYC area?
> > I appear to be getting a cartesean product when I select against the view
> > 'addenda', when I want a left inner join. That is, I want documents
> > records matched to addenda records only when there is a record in
> > d_addenda with a documents_id that matches the id field in documents.
>
> I think this is the "adding a table into the FROM" feature of PG. You're
> referring to documents.xxx in the select and d.id in the FROM. PG tries to
> help out by adding the table into the FROM for you - hence cartesian join.
>
> I think you can turn this "feature" off in the config file in 7.3.x (haven't
> checked this though)
This was exactly it. Thanks for the help, this was really making me
crazy.
-j
--
Jamie Lawrence jal@jal.org
anger, bargaining, depression, and, finally, acceptance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgres@jal.org, dev@archonet.com
Subject: Re: Fwd: Bad Join moment - how is this happening?
In-Reply-To: <20030801170242.GG1073@jal.clueinc.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox