Is it possible to join two tables by the nearest date? For example how could I find out where the user was on their birthday?
users (id, name, birthday) 1 | one | 2009-07-27 2 | two | 2009-07-28 3 | three | 2009-07-29 4 | four | 2009-07-30 5 | five | 2009-07-31 users_locations (id, user_id, created) 1 | 1 | 2009-05-21 2 | 1 | 2009-06-21 3 | 1 | 2009-07-21 4 | 2 | 2009-05-10 5 | 2 | 2009-06-10 6 | 2 | 2009-07-10 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
