ERROR: pull_var_clause: Cannot handle node type 108

From: José Soares <jose(at)sferacarta(dot)com>
To: hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: ERROR: pull_var_clause: Cannot handle node type 108
Date: 1999-08-23 13:03:29
Message-ID: 37C146A1.9DB058FE@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

What does it mean?

prova=> select nome from prova group by nome having count(*) > 1;
nome
Carlos
Henrique
Jose
(3 rows)

prova=> select oid,* from prova where nome in (select nome from prova
group by nome having 1 < count(*));
ERROR: pull_var_clause: Cannot handle node type 108

prova=> select * from prova where nome in (select nome from prova group
by nome having count(*) > 1);
ERROR: rewrite: aggregate column of view must be at rigth side in qual

José

Browse pgsql-hackers by date

  From Date Subject
Next Message Alke 1999-08-23 13:37:37 Array-fields and many-to-many relations
Previous Message Zakkr 1999-08-23 11:56:31 trigger: run in transaction