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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Query returning tuples that does not satisfy the WHERE clause
Date: 2006-09-08 18:18:26
Message-ID: 21303.1157739506@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Manuel Sugawara <masm(at)fciencias(dot)unam(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Manuel Sugawara 2006-09-08 18:25:12 Re: Query returning tuples that does not satisfy the WHERE clause
Previous Message Simon Riggs 2006-09-08 17:59:47 Re: [HACKERS] Simplifying "standby mode"