Re: Join tables by nearest date?

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