Re: How To Exclude True Values

> Richard, that is the result i would need given that
> data set. i have to digest this version, though.
>
> should this query be more efficient than the subquery
> version as the table starts to get large?

My experience is that Distinct On queries do not preform as well as their group by counter parts.
I believe that others have also commented to the same effect.

To speed the query you could apply indexes on the group by fields and the join columns.

Also, I produced a second query using PostgreSQL:

select a.id_i, a.ir_id, a.test, a.stamp
from test a

join
(
select max(stamp) as mstamp, id_i
from test
group by id_i
) b

on a.stamp = b.mstamp

where a.test = false
;

-- result

id_i | ir_id | test | stamp
------+-------+------+---------------------
4 | 8 | f | 2006-06-05 08:00:00