X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 0F1B5D97CD
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat,  1 Oct 2005 19:32:54 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 71338-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat,  1 Oct 2005 22:32:49 +0000 (GMT)
Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2])
	by svr1.postgresql.org (Postfix) with ESMTP id D030DD9604
	for <pgsql-sql@postgresql.org>; Sat,  1 Oct 2005 19:32:50 -0300 (ADT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id C615B31F51; Sun,  2 Oct 2005 00:32:51 +0200 (MET DST)
From: brett <bhalligan@yahoo.com>
X-Newsgroups: pgsql.sql
Subject: BirthDay SQL Issue
Date: Sat, 01 Oct 2005 23:32:05 +0100
Organization: hrm
Reply-To: bhalligan@yahoo.com
Message-ID: <ji3uj1lqok26mll7bugc8rhpqk56s45m6j@4ax.com>
X-Newsreader: Forte Agent 3.0/32.763
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 35
X-Complaints-To: abuse@newshosting.com
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=2.174 required=5 tests=[FORGED_YAHOO_RCVD=2.174]
X-Spam-Level: **
X-Archive-Number: 200510/24
X-Sequence-Number: 22877

Hi there

This is my first posting here, please forgive me if I make any
mistakes here.

Ok 

I have the structure 

{CLIENTS} = Client ID, First Name, Surname, DOB, Address, Home Phone
No, Mobile Phone No

As one relation / table (There are several others in this db that are
not related to this issue)

My problem is this

I need to be able to select two dates on my webby so I have a range of
dates 

E.G. (using English date format DD/MM/YYYY)

01/09/2005 to 01/10/2005

Then I want to be able to get, using some nifty query, everyone's
birthday that falls between those two dates. So if someone's birthday
was 04/09/79 it would return that tuple

I have been stuck on this for ages. Any my search for help has brought
me here.

If anyone out there can help me, in any way, I would be very grateful.

Kind regards
Brett Halligan