CASE statement causes unknown node type 723

Поиск
Список
Период
Сортировка
От Nathan Angelacos
Тема CASE statement causes unknown node type 723
Дата
Msg-id 19990817233109.AAA29141@dorsey.fcc.net@compaq
обсуждение исходный текст
Ответы Re: [SQL] CASE statement causes unknown node type 723  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.


В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] index on more-than-one columns?
Следующее
От: "Hamid Khoshnevis"
Дата:
Сообщение: Using intersect in subquery