Hi all,
I'm running PostgreSQL v 8.1.4 and found a query that returns tuples
that does not satisfy the WHERE clause, the query is:
select * into errores_20071 from (
select r.id, r.trayectoria_id, r.grupo_id,
regacd.insc_registra_grupo(trayectoria_id, grupo_id, true, false, true) as
error
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
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 looking
Manuel Sugawara masm@fciencias.unam.mx 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