Ian Percival <ian(at)emergence(dot)com> writes:
> SQL THAT IS THROWING ERROR:
> select
> calendar_date
> from
> official_hour
> where
> official_hour is not null
> and office_closed = False
> and calendar_date >= date'2004/01/01'
> and calendar_date <= date'2004/08/23'
> order by
> calendar_date
> RESULTS:
> ProgrammingError: ERROR: expression_tree_walker: Unexpected node type 711
> Anyone see something here I don't?
7.4 will give a more helpful error message:
ERROR: relation reference "official_hour" cannot be used in an expression
regards, tom lane