CASE statement causes unknown node type 723

From: "Nathan Angelacos" <nba(at)fcc(dot)net>
To: pgsql-sql(at)hub(dot)org
Subject: CASE statement causes unknown node type 723
Date: 1999-08-17 23:36:27
Message-ID: 19990817233109.AAA29141@dorsey.fcc.net@compaq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On a
[PostgreSQL 6.5.1 on i586-pc-linux-gnu, compiled by gcc egcs-2.91.66]
(Redhat) system, I get an unknown node type 723 error when trying to
do a pg_dump on a db, or specifically, trying to select from pg_views
after creating a view with a CASE statement.

To duplicate:
in any database (e.g. template1)

=>select * from pg_views
(Returns the expected results)

=> create view die as
=> select
=> CASE when usename = 'postgres' then 'something'
=> ELSE usename
=> End
=> from pg_user;
(Creates view 'die')

=>select * from die
(Works fine, but now....)

=>select * from pg_views

root=> select * from pg_views;

ERROR: get_ruledef of die: unknown node type 723 in
check_if_rte_used()

Is it a bug, or am I doing something stupid?

Thanks.

Browse pgsql-sql by date

  From Date Subject
Next Message Hamid Khoshnevis 1999-08-18 00:48:18 Using intersect in subquery
Previous Message Tom Lane 1999-08-17 21:04:29 Re: [SQL] index on more-than-one columns?