Re: expression_tree_walker: Unexpected node type 711 - Mailing list pgsql-sql

Ian Percival <ian@emergence.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