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