Re: Another orderby problem

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.


HTH, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===