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 6: Have you searched our list archives?
http://archives.postgresql.org
