On 6 Jan 2003, Felipe Schnack wrote:
> I have a table called "questionarios" (sorry, it's portuguese), and
> its primary key is a field called "codquestionario". Why pgsql doesn't
> "throw" an error when this query is executed?
> select * from questionarios q where questionarios.codquestionario = 1
> In my opinion, "questionarios" should not be valid in this query, only
> "q", but for some reason the condition "questionarios.codquestionario"
> just get ignored and all records are returned.
> Why??
You probably should be getting a notice with that query.
NOTICE: Adding missing FROM-clause entry for table "questionarios"
It realizes the query is invalid as is and attempts to add questionarios
to the from list to make it valid, thus the query you're really running
is:
select * from questionarios q, questionarios where
questionarios.codquestionario = 1;
