Query returning tuples that does not satisfy the WHERE clause

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Query returning tuples that does not satisfy the WHERE clause
Date: 2006-09-08 16:53:10
Message-ID: m3r6ymnvux.fsf@conexa.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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
from regacd.registro r join regacd.grupo g on (g.id = r.grupo_id)
where g.año_semestre = 20071 and g.tipo_id = 'a') x
where error is not null;

A self-contained database schema is here:

Attachment Content-Type Size
schema-registro.sql application/octet-stream 5.4 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2006-09-08 16:53:18 Re: postgresql shared buffers
Previous Message Praveen Kumar N 2006-09-08 16:35:03 Re: postgresql shared buffers