Try create NEWtable (userid text, val integer, ts timestamp); insert into NEWtable select userid, val, max(ts) from table group by userid, val;
Regards, Christoph > > Hi, > > I have a table which basically looks like this: > > create table (userid text, val integer, ts timestamp); > > This table holds multiple values for users, timestamped for history > reasons. > > Now I need to fetch the latest val for each userid to insert into a new > table (with about the same schema, except for uniqueness on userid). > I belive this should be a trivial task, but I'm experience total lack of > insight here... > > Comments? > > /Patrik Kudo > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
