Thank you for your quick feedback,
In my opinion, your query should return :
Id, Text
1| 1, 'one'
and be interpreted as due to variable type :
LIMIT CASE WHEN 1 = 1 THEN 1 ELSE 2 END;
Am I wrong in the way I see the situation ?
I think that in the case of a variable, the data should be retrieved until the condition is reached. Like LIMIT_TILL {condition}
Marwan L.
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:
I don't see the point, what is the main difference between
summary.amount_summed which is a float, and directly pass 100.0 ?
A limit applies to the query as a whole and cannot depend on individual records. If you think that is wrong explain what the following query is supposed to return and why.
SELECT *
FROM (VALUES (1, 'one'), (2, 'two')) vals (i, t)
LIMIT CASE WHEN vals.i = 1 THEN 1 ELSE 2 END;
David J.