Carl Anderson (candrsn(at)mindspring(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
case and LIMIT not working together
Long Description
PostreSQL 7/1/3 i686-pc-linux-gnu compiled by GCC 3.0
when I count ( case ... ) LIMIT
The count is from the entire table not from the LIMIT
in the below example the count is returned with the
same value in all three statements
Sample Code
select count( case when b='T' then 1 else null) from test limit 50;
select count( case when b='T' then 1 else null) from test;
select count(*) from test where b = 'T';
No file was uploaded with this report