X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id A819E5E46F8
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Aug 2004 12:56:49 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 09950-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Aug 2004 15:56:54 +0000 (GMT)
Received: from newmail.emergence.com (newmail.emergence.com [209.5.172.115])
	by svr1.postgresql.org (Postfix) with ESMTP id 6A2795E46E7
	for <pgsql-sql@postgresql.org>; Thu, 26 Aug 2004 12:56:45 -0300 (ADT)
Received: from baffin.emergence.com ([209.5.172.48])
	by newmail.emergence.com with esmtp (TLSv1:RC4-MD5:128) (Exim 4.10)
	id 1C0McX-0003JU-00
	for pgsql-sql@postgresql.org; Thu, 26 Aug 2004 09:57:01 -0600
Message-ID: <412E0892.7090202@emergence.com>
Date: Thu, 26 Aug 2004 09:58:10 -0600
From: Ian Percival <ian@emergence.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.7.2) Gecko/20040803
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: expression_tree_walker: Unexpected node type 711
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200408/321
X-Sequence-Number: 18818

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