Received: from gumby.wpl.com (mailgate.wpl.com [198.7.47.55]) by hub.org (8.8.8/8.7.5) with SMTP id WAA04572 for ; Wed, 10 Jun 1998 22:41:10 -0400 (EDT) Received: from maestro by gumby.wpl.com (SMI-8.6/SMI-SVR4) id VAA28390; Wed, 10 Jun 1998 21:39:41 -0500 Message-ID: <357F4370.5BB8@writeme.com> Date: Wed, 10 Jun 1998 21:39:44 -0500 From: Tim J Trowbridge Reply-To: trowbrid@writeme.com X-Mailer: Mozilla 3.0Gold (WinNT; U) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Order by birthdate Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I'm trying to generate a birthday list ordered by month, then by day. This is what I thought would work... SELECT name,birthdate FROM table WHERE birthdate is not null ORDER BY date_part('month',birthdate) but psql returns: ERROR: parser: parse error at or near "(" What's the problem? -- Tim J Trowbridge trowbrid@writeme.com Interested in my genealogy? http://www.execpc.com/~trowbrid