Join Problem - Mailing list pgsql-general

From Rob Sell
Subject Join Problem
Date
Msg-id 007301c35153$c2730880$640101c0@rob
Whole thread Raw
Responses Re: Join Problem  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
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.

TIA for any help you can provide.

Rob


pgsql-general by date:

Previous
From: "Claudio Lapidus"
Date:
Subject: Re: Convert TimeStamp to Date
Next
From: Franco Bruno Borghesi
Date:
Subject: Re: 0/1 vs true/false