"Alex Page" <[EMAIL PROTECTED]> writes: > I'm trying to write a query that returns the rows containing the > most recent values for each foreign key. The best way to do this (on every dimension except portability :-() is SELECT DISTINCT ON. See the weather-report example in the SELECT reference page. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly