bug with if ... then ... clause in views - Mailing list pgsql-general

From Emil Rachovsky
Subject bug with if ... then ... clause in views
Date
Msg-id 20060118091815.83323.qmail@web54314.mail.yahoo.com
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Stephen Friedrich
Date:
Subject: Re: Partitioning: Planner makes no use of indexes on inherited
Next
From: Michael Glaesemann
Date:
Subject: Re: [SQL] bug with if ... then ... clause in views