Re: [SQL] Order by birthdate

On Wed, 10 Jun 1998, Tim J Trowbridge wrote:

> 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)

I don't understand why you need specify month to sort tuples, you may order
it by birthday, but if you want it anyway try this:

SELECT name, EXTRACT(month FROM birthdate) AS mese
      FROM table WHERE birthdate is not null
      ORDER BY mese
> 
> but psql returns:
> 
> ERROR:  parser: parse error at or near "("
> 
> What's the problem?
Seems that order by doesn't supports a function as parameter.
                                  Jose'