parser error? - Mailing list pgsql-general

From Felipe Schnack
Subject parser error?
Date
Msg-id 1041876943.3212.132.camel@desenv1.ritterdosreis.br
Whole thread Raw
Responses Re: parser error?
List pgsql-general
  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??

--

Felipe Schnack
Analista de Sistemas
felipes@ritterdosreis.br
Cel.: (51)91287530
Linux Counter #281893

Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter@ritterdosreis.br
Fone/Fax.: (51)32303341


pgsql-general by date:

Previous
From: Alan Gutierrez
Date:
Subject: Re: www.postgresql.org
Next
From: "Marc G. Fournier"
Date:
Subject: Re: www.postgresql.org