| From: | michael(at)aplaypowered(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #11661: CASE ELSE is evaluated although condition is true |
| Date: | 2014-10-13 11:05:42 |
| Message-ID: | 20141013110542.25460.3900@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-docs |
The following bug has been logged on the website:
Bug reference: 11661
Logged by: Michael Stieler
Email address: michael(at)aplaypowered(dot)com
PostgreSQL version: 9.2.6
Operating system: RHEL
Description:
I am not sure if it is a bug, a lack in documentation or just a
misunderstanding.
This issue refers to a StackOverflow question at
https://stackoverflow.com/questions/26297035/posgtres-case-condition-with-sum-aggregation-evaluates-not-needed-else-part
The following query:
case when sum( column1 ) = 0
then 0
else round( sum( price
* hours
/ column1 ), 2 )
raises a division by zero error, although the condition sum(column1) = 0 is
true. I would expect that the else part would never be evaluated.
Documentation only describes that this happens for immediates.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-10-13 14:04:41 | Re: BUG #11660: TSVector not returning partial match on word "out" |
| Previous Message | david.g.levy | 2014-10-13 00:47:42 | BUG #11660: TSVector not returning partial match on word "out" |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2014-10-13 21:24:00 | Re: Huge pages section needs to describe hugetlb_shm_group, memlock limit |
| Previous Message | Ian Barwick | 2014-10-09 22:49:28 | Re: Documentation for CREATE USER |