Skip site navigation (1) Skip section navigation (2)

Re: BUG #4997: Expression evaluation rules

From: "Dmitry Samokhin" <sdld(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4997: Expression evaluation rules
Date: 2009-08-20 14:27:54
Message-ID: h6jmh6$2dtd$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Yes... Described in "38.4. Expressions"...

To be more exact, it's neither bug nor feature. To evaluate an integral CASE 
... END expression, the 'main' SQL engine needs all its parameters passed to 
exist at least. But the evaluation rules (I think) remain the same both in 
separate SQL queries and server procedures.

Thanks for reply,
closed.

Dmitry. 



In response to

pgsql-bugs by date

Next:From: Brian CeccarelliDate: 2009-08-20 20:24:53
Subject: BUG #4999: select 'a' < 'A' is true, but should be false . . .
Previous:From: Pavel StehuleDate: 2009-08-20 09:42:06
Subject: Re: BUG #4997: Expression evaluation rules

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group