Column reference X is ambiguous?

Поиск
Список
Период
Сортировка
От Palle Girgensohn
Тема Column reference X is ambiguous?
Дата
Msg-id 3B10915E.70D7A758@partitur.se
обсуждение исходный текст
Список pgsql-sql
Hi!

SELECT count(rf.userid) as count, rf.userid FROM read_faq rf,
faq f,deltagare_saved d, person p WHERE rf.id = f.id AND f.kursid=20
ANDd.course_id = f.kursid AND d.userid = rf.userid ANDp.userid = d.userid GROUP BY userid
ERROR:  Column reference "userid" is ambiguous


All of the tables have a userid, yes, but this query didn't
fail before 7.1.x. Is it really OK to fail in this case? I
thought SQL standard requires all GROUP|ORDER BY arguments to
acutally exist on the SELECT target list. Then, this makes me
puzzled... Are the joins making the userids get included in the
target in some hidden way?

/Palle


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

Предыдущее
От: jim_esti@hotmail.com (Jim)
Дата:
Сообщение: Difficult SQL Statement
Следующее
От: "Sergey E. Volkov"
Дата:
Сообщение: Re: Return cursor