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

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

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> You seem to have worse problems than that, because as given the
> insc_registra_grupo function never returns non-NULL

Actually the function (and the database) is quite complex and was
trimed just to test the problem.

> I suspect pilot error --- perhaps looking at the wrong schema or
> some such?

I don't think so, search_path has its default value and also I'm able
to reproduce it in a fresh cluster (tried 3 different machines to
discard hardware problems).

Regards,
Manuel.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message mark 2006-09-08 18:31:32 Re: Fixed length data types issue
Previous Message Tom Lane 2006-09-08 18:18:26 Re: Query returning tuples that does not satisfy the WHERE clause