On Fri, Jun 21, 2002 at 10:30:54 +0200, Michael Agbaglo <[EMAIL PROTECTED]> wrote: > > of course you could sort by DOY but then you'll have a problem w/ the > next year: > > if it's let's say december and you select the list for the next 60 days, > persons having birthday in december will appear after persons having > birthday in january. > > I tried to use CASE WHEN... THEN in ORDER BY but it doesn't seem to work > (syntax error at '')
You also need to worry about leap years. If a birthday is February 29 and there isn't one this year, what do you want to happen? ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
