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

Eric D Nielsen <nielsene@MIT.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