Re: GROUP BY + join regression in 7.3
От | Joe Conway |
---|---|
Тема | Re: GROUP BY + join regression in 7.3 |
Дата | |
Msg-id | 3E893061.4000501@joeconway.com обсуждение исходный текст |
Ответ на | Re: GROUP BY + join regression in 7.3 (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
Tom Lane wrote: > Just out of curiosity --- Here's what I get: select * from t1 f1 f2 ----------- ----------- 1 1 2 2 (2 row(s) affected) select * from t2 f2 f3 ----------- ----------- 1 3 (1 row(s) affected) select t1.f2 from t2 right join t1 on t1.f2 = t2.f2 group by f2 Server: Msg 209, Level 16, State 1, Line 1 Ambiguous column name 'f2'. select f2 from t2 right join t1 on t1.f2 = t2.f2 group by t1.f2 Server: Msg 209, Level 16, State 1, Line 1 Ambiguous column name 'f2'. select f2 from t2 right join t1 on t1.f2 = t2.f2 group by f2 Server: Msg 209, Level 16, State 1, Line 1 Ambiguous column name 'f2'. Server: Msg 209, Level 16, State 1, Line 1 Ambiguous column name 'f2'. select t1.f2 from t2 right join t1 on t1.f2 = t2.f2 group by t1.f2 f2 ----------- 1 2 (2 row(s) affected) Any other variations you want to see? Joe
В списке pgsql-hackers по дате отправления: