Nikolas Everett <nik9000(at)gmail(dot)com> wrote:
> I'm really going to be doing this with an arbitrary list of As.
OK, how about this?:
CREATE TEMPORARY TABLE request (a INTEGER NOT NULL);
INSERT INTO request SELECT a FROM generate_series(2, 200) AS t(a);
ANALYZE request;
SELECT y.*
from (select a, max(revision) as revision
from test join request using (a)
group by a) x
join test y using (a, revision);
DROP TABLE request;
-Kevin