From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Jamie Lawrence <postgres@jal.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: Fwd: Bad Join moment - how is this happening?
Date: Wed, 30 Jul 2003 12:39:35 -0700 (PDT)
Message-ID: <20030730123546.X39594-100000@megazone.bigpanda.com> (raw)
In-Reply-To: <20030730200732.GW1073@jal.clueinc.net>
On Wed, 30 Jul 2003, Jamie Lawrence wrote:
> I have a view:
>
> create or replace view addenda as
> select
> documents.id,
> documents.oid,
> documents.projects_id,
> documents.doc_num,
> documents.description,
> documents.date,
> documents.createdate,
> documents.moddate,
> documents.people_id,
> documents.parent,
> documents.document_type,
> documents.state,
> documents.machines_id,
> documents.phases_id,
>
> d_addenda.item_num,
> d_addenda.drawing_reference
>
> from
> d_addenda as a, documents as d
> where a.documents_id = d.id;
I think you're being bitten by from clause
addition. You're referencing documents in the
select list rather than d so it's probably
adding an unconstrained join to documents.
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: sszabo@megazone.bigpanda.com, postgres@jal.org
Subject: Re: Fwd: Bad Join moment - how is this happening?
In-Reply-To: <20030730123546.X39594-100000@megazone.bigpanda.com>
* 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