From: Ian Percival <ian@emergence.com>
To: pgsql-sql@postgresql.org
Subject: expression_tree_walker: Unexpected node type 711
Date: Thu, 26 Aug 2004 09:58:10 -0600
Message-ID: <412E0892.7090202@emergence.com> (raw)
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
--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ian@emergence.com
Subject: Re: expression_tree_walker: Unexpected node type 711
In-Reply-To: <412E0892.7090202@emergence.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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