The following bug has been logged on the website:
Bug reference: 15904
Logged by: Lakradi Marwan
Email address: lakradimarwan@gmail.com
PostgreSQL version: 11.4
Operating system: Mac OS X - High Sierra
Description:
Good afternoon,
I would like to be able to conditionally limit my query (without python
script) based on a column value (for dynamic limit)
See example below:
SELECT summary.*
FROM
(
SELECT
id,
amount, date,
SUM(amount) OVER (PARTITION BY customer ORDER BY date, id) as
amount_summed
FROM
customer
ORDER BY date DESC, id DESC
) AS summary
LIMIT CASE WHEN summary.amount_summed >= 0 THEN summary.id ELSE NULL END;
The limit doesn't work, whereas :
- LIMIT CASE WHEN 100.0 >= 0 THEN 10 ELSE NULL END;
works well !
I don't see the point, what is the main difference between
summary.amount_summed which is a float, and directly pass 100.0 ?