Re: Query returning tuples that does not satisfy the WHERE clause

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query returning tuples that does not satisfy the WHERE clause
Дата
Msg-id 21303.1157739506@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Query returning tuples that does not satisfy the WHERE clause  (Manuel Sugawara <masm@fciencias.unam.mx>)
Ответы Re: Query returning tuples that does not satisfy the WHERE clause  (Manuel Sugawara <masm@fciencias.unam.mx>)
Список pgsql-hackers
Manuel Sugawara <masm@fciencias.unam.mx> writes:
> Using the second plan the query is returning tuples where
>    a=F1o_semestre <> 20071

You seem to have worse problems than that, because as given the
insc_registra_grupo function never returns non-NULL, and so the
query ought not be returning any tuples at all.  I suspect pilot
error --- perhaps looking at the wrong schema or some such?
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: elein
Дата:
Сообщение: Re: Domains and subtypes, a brief proposal
Следующее
От: mark@mark.mielke.cc
Дата:
Сообщение: Re: Fixed length data types issue