Re: Best way to get the latest revision from a table

["Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx>]

Nikolas Everett <nik9000@xxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance