| From: | Felipe Schnack <felipes(at)ritterdosreis(dot)br> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | parser error? |
| Date: | 2003-01-06 18:15:42 |
| Message-ID: | 1041876943.3212.132.camel@desenv1.ritterdosreis.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)ritterdosreis(dot)br
Cel.: (51)91287530
Linux Counter #281893
Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter(at)ritterdosreis(dot)br
Fone/Fax.: (51)32303341
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2003-01-06 18:22:59 | Re: [GENERAL] www.postgresql.org |
| Previous Message | Alan Gutierrez | 2003-01-06 18:04:00 | Re: www.postgresql.org |