Column reference X is ambiguous?

From: Palle Girgensohn <girgen(at)partitur(dot)se>
To: pgsql-sql(at)postgresql(dot)org
Subject: Column reference X is ambiguous?
Date: 2001-05-27 05:32:14
Message-ID: 3B10915E.70D7A758@partitur.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
AND
d.course_id = f.kursid AND d.userid = rf.userid AND
p.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

Browse pgsql-sql by date

  From Date Subject
Next Message Torsten Knodt 2001-05-27 10:57:47 Is it possible to defer triggers?
Previous Message Tom Lane 2001-05-26 14:53:56 Re: corrupted tables !!!