Re: expression_tree_walker: Unexpected node type 711

Ian Percival 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html