Re: Join Problem - Mailing list pgsql-general

From scott.marlowe
Subject Re: Join Problem
Date
Msg-id Pine.LNX.4.33.0307231353060.22923-100000@css120.ihs.com
Whole thread Raw
In response to Join Problem  ("Rob Sell" <robs@facnd.com>)
Responses Re: Join Problem  ("Rob Sell" <robs@facnd.com>)
Re: Join Problem  ("Rob Sell" <robs@facnd.com>)
List pgsql-general
On Wed, 23 Jul 2003, Rob Sell wrote:

> We are migrating to a new database server and one piece of code doesn't work
> from the old to new.
> Old server is 7.2.1
> New server is 7.3.2
>
> The sql in question is "Select * from inven as i Left Outer Join conn_xr as
> c on i.partnum = c.facpn"
>
> This produces the desired effects on the 7.2.1 server but doesn't work as
> expected on 7.3.2
>
> I have looked at the release notes from 7.2.1 through 7.3.2 and didn't see
> any mention of anything that would affect that particular command.

I'm not sure you've given us enough info to help you.  Is there anything
odd about your table structure?  Maybe the two databases were inited with
different locales?  Maybe some sample schema and data might help...


pgsql-general by date:

Previous
From: Franco Bruno Borghesi
Date:
Subject: Re: 0/1 vs true/false
Next
From: "Rob Sell"
Date:
Subject: Re: Join Problem