In response to Sam Mason : > On Mon, Jul 27, 2009 at 10:51:00PM -0700, Nick wrote: > > 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? > > DISTINCT ON[1] is normally the easiest way: > > SELECT DISTINCT ON (u.id) u.id, l.id, l.created > FROM users u, users_locations l > WHERE u.id = l.user_id > AND u.birthday <= l.created
AND u.birthday >= l.created Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
