pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedexpression_tree_walker: Unexpected node type 711
2+ messages / 2 participants
[nested] [flat]
* expression_tree_walker: Unexpected node type 711
@ 2004-08-26 15:58 Ian Percival <ian@emergence.com>
2004-08-29 16:26 ` Re: expression_tree_walker: Unexpected node type 711 Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Ian Percival @ 2004-08-26 15:58 UTC (permalink / raw)
To: pgsql-sql
I am having a problem with a select statement and the error
expression_tree_walker: Unexpected node type 711 is being returned when
I am trying to execute a rather simple SELECT statement.
Any insight anyone could give me would be greatly appreciated. And if
this is the wrong place to ask this then if someone could point me in
the right direction that would be swell.
TALE STRUCTURE:
Table "public.official_hour"
Column | Type | Modifiers
-----------------------+------------------+-----------
calendar_date | date | not null
official_opening_hour | double precision |
office_closed | boolean |
Indexes: official_hour_pkey primary key btree (calendar_date)
SOME DATA THAT LIVES IN TABLE:
select * from official_hour limit 10;
calendar_date | official_opening_hour | office_closed
---------------+-----------------------+---------------
2018-11-08 | |
2018-11-09 | |
2018-11-10 | | t
2018-11-11 | | t
2018-11-12 | |
2018-11-13 | |
2018-11-14 | |
2004-08-11 | 9 | f
2004-08-12 | 9 | f
2004-08-13 | 9 | f
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? Could this be a result of having a
date object as part of the primary key?
--
Ian Percival - Developer
mailto:ian@emergence.com
phone: 780.413.6397 ext. 226
Emergence by Design
http://www.emergence.com
mailto:info@emergence.com
toll free: 1.866.860.2666
--
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: expression_tree_walker: Unexpected node type 711
2004-08-26 15:58 expression_tree_walker: Unexpected node type 711 Ian Percival <ian@emergence.com>
@ 2004-08-29 16:26 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2004-08-29 16:26 UTC (permalink / raw)
To: Ian Percival <ian@emergence.com>; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-08-29 16:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-26 15:58 expression_tree_walker: Unexpected node type 711 Ian Percival <ian@emergence.com>
2004-08-29 16:26 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox