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
