Re: still sorting and casting problems

--- juerg.rietmann@pup.ch wrote:
> I need to sort the query by the log_date desc
> (log_date is char(10)). I
> tried the following without success :
> 
> select id, log_date from userlog order by cast
> (log_date as date) desc
> 
> select id, log_date from userlog order by
> date(log_date) desc
> 
> Please help and thank's in advance ... jr
> 
You haven't shown the error message here, but I'm
guessing that there is no direct cast between char and
date available in PostgreSQL.  Try casting first to
text, then to date.

__________________________________________________
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com