messages (id, to_user, from_user, created) 1 | 1 | 2 | 2009-05-21 2 | 1 | 3 | 2009-06-21 3 | 1 | 4 | 2009-07-21 4 | 2 | 1 | 2009-05-10 5 | 2 | 3 | 2009-06-10 6 | 1 | 2 | 2009-07-10 How could I get the most recent message between two users? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general