Re: [SQL] Order by birthdate - Mailing list pgsql-sql

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

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

Two problems here:

1. The date_part() which u use in the order by clause is not in the target
list

2. Even if it was it wouldn't work as AFAIK functions are not allowed in
the order by clause

Try this:

 SELECT name,birthdate, date_part('month',birthdate) as birth_month
 FROM table
 WHERE birthdate is not null
 ORDER BY birth_month;


Any better idea???

    Marin



          -= Why do we need gates in a world without fences? =-