For the first request (How can i select only the newest record for each ProdId ?), you can do :
select * from test."tableProd" u
where u."LastUpdate" = (select max(t."LastUpdate") from test."tableProd" t
where u."ProdId" = t."ProdId")
Although this only guarantees one row if LastUpdate is unique for every ProdId.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
