[GENERAL] Ordering problem with varchar (DESC)

2007-01-31 Thread Alexandre Leclerc
t the result is exactly like the first one but perfectly reversed in it's order? Best regards. -- Alexandre Leclerc ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Ordering problem with varchar (DESC)

2007-01-31 Thread Alexandre Leclerc
t; needs to be 09h30 and so forth. Exactly. This is sorted that way. This is what I'll do, inserting a 0. Best regards. -- Alexandre Leclerc ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to c

Re: [GENERAL] Ordering problem with varchar (DESC)

2007-01-31 Thread Alexandre Leclerc
Daniel Verite a écrit : > Alexandre Leclerc wrote: > >> SELECT * from t1 ORDER BY date, time DESC; >> date (date type) time (varchar) data >> 2007-01-30 9h30 d2 >> 2007-01-3017h20 d5 >> 2007-01-3013h45

[GENERAL] Ordering problem with varchar (DESC)

2007-01-31 Thread Alexandre Leclerc
t the result is exactly like the first one but perfectly reversed in it's order? Best regards. -- Alexandre Leclerc Projets spéciaux Ipso Systèmes Stratégiques inc. 176 boul. Harwood (suite 10), Vaudreuil-Dorion, QC, J7V 1Y2 Tel: 450-424-6847 ext. 108 / 1-800-879-4776 Fax: 450-424-843