parser error?

Поиск
Список
Период
Сортировка
Искать
От
Felipe Schnack
Тема
parser error?
Дата
Msg-id
1041876943.3212.132.camel@desenv1.ritterdosreis.br
Список
Дерево обсуждения
parser error? Felipe Schnack <felipes@ritterdosreis.br>
Re: parser error? Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: parser error? Felipe Schnack <felipes@ritterdosreis.br>
Re: parser error? Stephan Szabo <sszabo@megazone23.bigpanda.com>
  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 по дате отправления
От: Alan Gutierrez
Дата:
Сообщение: Re: www.postgresql.org
От: Marc G. Fournier
Дата:
Сообщение: Re: www.postgresql.org
FAQ