Re: Another orderby problem

On Saturday 14 January 2006 13:09, A. Kretschmer wrote:
> am  14.01.2006, um 13:02:48 +0000 mailte Alan Chandler folgendes:
> > select name, id, transaction.date as tdate, description, amount
> > from account join transaction on name=dst where name ='Sarah'
> > order by tdate asc;
> >
> >  name  | id |   tdate    |        description        | amount
> > -------+----+------------+---------------------------+--------
> >  Sarah | 12 | 0005-06-05 | Ben 21st Birthday Pressie |     41
> >  Sarah | 13 | 0005-06-05 | Cash from Mum             |     60
> >  Sarah | 14 | 0005-06-08 | Petrol                    |  27.33
> >  Sarah | 15 | 0005-06-10 | Petrol Allowance          |    -40
> >  Sarah | 11 | 2005-06-05 | Sarah Petrol              |  27.74
> > (5 rows)
> >
> > I can't figure out why the dates are not in order (see transaction 11 is
> > out of place).
>
> '0005-06-10' < '2005-06-05'. Perhaps you have a wrong year.

Thanks

Its amazing how long you can stare at something and not see the obvious.

-- 
Alan Chandler
http://www.chandlerfamily.org.uk
Open Source. It's the difference between trust and antitrust.