Join Problem

From: "Rob Sell" <robs(at)facnd(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Join Problem
Date: 2003-07-23 19:51:08
Message-ID: 007301c35153$c2730880$640101c0@rob
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-07-23 19:55:12 Re: Join Problem
Previous Message Claudio Lapidus 2003-07-23 19:28:56 Re: Convert TimeStamp to Date