Postgres Pro
Downloads
Home   >   mailing lists

Order by birthdate - Mailing list pgsql-sql

From Tim J Trowbridge
Subject Order by birthdate
Date
Msg-id 357F4370.5BB8@writeme.com
Whole thread Raw
Responses Re: [SQL] Order by birthdate  (Marin D <marin@cybernet.bg>)
Re: [SQL] Order by birthdate  ("Jose' Soares Da Silva" <sferac@bo.nettuno.it>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: lynch@lscorp.com (Richard Lynch)
Date:
Subject: insert/select returned table
Next
From: Marin D
Date:
Subject: Re: [SQL] Order by birthdate