ERROR: pull_var_clause: Cannot handle node type 108 - Mailing list pgsql-hackers

From José Soares
Subject ERROR: pull_var_clause: Cannot handle node type 108
Date
Msg-id 37C146A1.9DB058FE@sferacarta.com
Whole thread Raw
Responses Re: [HACKERS] ERROR: pull_var_clause: Cannot handle node type 108
List 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é




pgsql-hackers by date:

Previous
From: Zakkr
Date:
Subject: trigger: run in transaction
Next
From: Alke
Date:
Subject: Array-fields and many-to-many relations