Re: ExecEvalExpr: unknown expression type 704 problems...

Eric D Nielsen <nielsene(at)MIT(dot)EDU> writes:
> Sample query causing the problem:
> SELECT distinct title, collections.collectionid FROM collections
> LEFT OUTER JOIN team_items ON
> (collections.collectionid=team_items.collectionid)
> LEFT OUTER JOIN item_status ON
> (team_items.statusid=item_status.statusid)
> WHERE libraryid=1 AND (item_status IS NULL
> OR item_status.name<>'REFERENCE')
> ORDER BY title LIMIT 20 OFFSET 0;

> Resulting error message:
> ERROR: ExecEvalExpr: unknown expression type 704

I'm not really interested in trying to reverse-engineer your schema.
Could you supply a complete runnable example, rather than a fragment?

regards, tom lane