Postgres Pro
Downloads
Home   >   mailing lists

Re: Fwd: Bad Join moment - how is this happening? - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Fwd: Bad Join moment - how is this happening?
Date
Msg-id 200307301225.25626.josh@agliodbs.com
Whole thread Raw
In response to Fwd: Bad Join moment - how is this happening?  (Jamie Lawrence <postgres@jal.org>)
List pgsql-sql
Tree view 
Jamie,

> General issue: I'm getting cartesean products instead of left joins, and
> I feel like a moron.

No, this is extremely bizarre.   I can't think of an explanation for the
results you're getting, except that the view definition isn't what you think
it is.  Can you do a \d addenda and post the results?

--
-Josh BerkusAglio Database SolutionsSan Francisco

pgsql-sql by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: ALTER TABLE ... DROP CONSTRAINT
Next
From: Dave Dribin
Date:
Subject: One to many query question