JOIN chaining not working in 7.1 beta 3

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема JOIN chaining not working in 7.1 beta 3
Дата
Msg-id web-1186399@davinci.ethosmedia.com
обсуждение исходный текст
Ответы Re: JOIN chaining not working in 7.1 beta 3  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Tom, Stephen,
I'm trying to parse a query like the following and keep
getting various errors (I'd give you the real query but
&%^$# Netscape won't do cut-and-paste):

SELECT a.1, b.2, c.14, a.2, c.5
FROM a INNER JOIN b ON a.1=b.3LEFT OUTER JOIN c on a.1=c.2;

And I get:
ERROR: JOIN/ON CLAUSE REFERS TO 'c' WHICH IS NOT PART OF
JOIN.

What's wrong here?

-Josh Berkus



______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Never mind (Directional Joins)
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Bug with rules in 7.0.3?