Received: from all.all.ee (puu.all.ee [194.204.49.113]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2MEokt72509 for ; Thu, 22 Mar 2001 09:50:47 -0500 (EST) (envelope-from alligator@all.ee) Received: from localhost (localhost [127.0.0.1]) by all.all.ee (8.9.3/8.9.3) with ESMTP id QAA12155 for ; Thu, 22 Mar 2001 16:50:33 +0200 Date: Thu, 22 Mar 2001 16:50:33 +0200 (EET) From: Antti Linno To: pgsql-sql@postgresql.org Subject: Birthday search. Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200103/447 X-Sequence-Number: 2115 I have a table with personal data, including date of birth in date format. What i need is a select that searches birthdays in certain range. E.g. I need to find all birthdays starting from 15.april until 20th december. As you all understand, year doesn't matter :P Any simple and elegant solutions to it? Greetings, Antti