bug with if ... then ... clause in views

Поиск
Список
Период
Сортировка
От Emil Rachovsky
Тема bug with if ... then ... clause in views
Дата
Msg-id 20060118091815.83323.qmail@web54314.mail.yahoo.com
обсуждение исходный текст
Ответы Re: [SQL] bug with if ... then ... clause in views  (Michael Glaesemann <grzm@myrealbox.com>)
Re: bug with if ... then ... clause in views  (Jeff <threshar@torgo.978.org>)
Список pgsql-general
While trying to create some views I stumbled on some
problem with using the if-then clause. Here is a
simple example :

CREATE OR REPLACE VIEW public.SomeView
  as select d.id,
  if (true) then d.DocNumber endif from
public.Z_Documents as d;

I get the following error :
 syntax error at or near "then" at character 72

I don't have a clue what is going on here. Any
suggestions?

Thanks in advance,
Emil

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

Предыдущее
От: Stephen Friedrich
Дата:
Сообщение: Re: Partitioning: Planner makes no use of indexes on inherited
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: [SQL] bug with if ... then ... clause in views