In rules.out it appears that the sort order is wrong. The SELECT * FROM
shoe_ready WHERE total_avail >= 2; first give a sh3, and then a sh1.
Can someone tell me where/or how the sorting is accomplished ? This
presumes that some sorting is done.
gat
BTW this appears to work on the redhat/i386 port . SO where has my alpha
gone wrong :-(
QUERY: SELECT * FROM shoelace ORDER BY sl_name;
sl_name |sl_avail|sl_color |sl_len|sl_unit |sl_len_cm
----------+--------+----------+------+--------+---------
sl1 | 5|black | 80|cm | 80
sl2 | 6|black | 100|cm | 100
sl3 | 0|black | 35|inch | 88.9
sl4 | 8|black | 40|inch | 101.6
sl5 | 4|brown | 1|m | 100
sl6 | 0|brown | 0.9|m | 90
sl7 | 7|brown | 60|cm | 60
sl8 | 1|brown | 40|inch | 101.6
(8 rows)
QUERY: SELECT * FROM shoe_ready WHERE total_avail >= 2;
shoename |sh_avail|sl_name |sl_avail|total_avail
----------+--------+----------+--------+-----------
sh3 | 4|sl7 | 7| 4
sh1 | 2|sl1 | 5| 2
(2 rows)
~
~