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

2006-09-08 Thread Tom Lane
Manuel Sugawara writes: > 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). Hm, well I'm willing to take a look if you can provide me access to the problem database running on a d

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

2006-09-08 Thread Manuel Sugawara
Tom Lane <[EMAIL PROTECTED]> 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 look

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

2006-09-08 Thread Tom Lane
Manuel Sugawara 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 suspe