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

From: Emil Rachovsky <zsevgymko(at)yahoo(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: bug with if ... then ... clause in views
Date: 2006-01-18 09:18:15
Message-ID: 20060118091815.83323.qmail@web54314.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2006-01-18 09:28:50 Re: [SQL] bug with if ... then ... clause in views
Previous Message Stephen Friedrich 2006-01-18 09:12:57 Re: Partitioning: Planner makes no use of indexes on inherited

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Glaesemann 2006-01-18 09:28:50 Re: [SQL] bug with if ... then ... clause in views
Previous Message Michael Glaesemann 2006-01-18 05:04:16 Re: Matching several rows