Re: [PORTS] RedHat6.0 & Alpha - Mailing list pgsql-ports

From Uncle George
Subject Re: [PORTS] RedHat6.0 & Alpha
Date
Msg-id 379760DD.59BFD53D@voicenet.com
Whole thread Raw
In response to Re: [PORTS] RedHat6.0 & Alpha  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-ports
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)

~
~



pgsql-ports by date:

Previous
From: Uncle George
Date:
Subject: Re: [PORTS] RedHat6.0 & Alpha
Next
From: Bruce Momjian
Date:
Subject: Re: [PORTS] RedHat6.0 & Alpha