Re: Join Problem

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: Join Problem
Дата
Msg-id Pine.LNX.4.33.0307231353060.22923-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Join Problem  ("Rob Sell" <robs@facnd.com>)
Ответы Re: Join Problem  ("Rob Sell" <robs@facnd.com>)
Re: Join Problem  ("Rob Sell" <robs@facnd.com>)
Список 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 по дате отправления:

Предыдущее
От: Franco Bruno Borghesi
Дата:
Сообщение: Re: 0/1 vs true/false
Следующее
От: "Rob Sell"
Дата:
Сообщение: Re: Join Problem