Re: Query returning tuples that does not satisfy the WHERE clause - Mailing list pgsql-hackers

From Manuel Sugawara
Subject Re: Query returning tuples that does not satisfy the WHERE clause
Date
Msg-id m37j0enrlj.fsf@conexa.fciencias.unam.mx
Whole thread Raw
In response to Re: Query returning tuples that does not satisfy the WHERE clause  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Query returning tuples that does not satisfy the WHERE clause  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.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.


pgsql-hackers by date:

Previous
From: mark@mark.mielke.cc
Date:
Subject: Re: Fixed length data types issue
Next
From: Tom Lane
Date:
Subject: Re: Domains and subtypes, a brief proposal