It actually does what I want... but it offends my database
sensibilities... :-)


Heres the basics of the tables involved:

CREATE TABLE bds_filesize (
    bds_filesize_id serial
    name text NOT NULL,
    byte_limit integer NOT NULL,
    slots integer NOT NULL
);


CREATE TABLE software (
    software_binary_id serial,
    binary_file oid,
    filename text,
    filesize integer,
    checksum text
);


query:

select 
        software_binary_id, min(byte_limit) 
from 
        bds_filesize, software_binary 
where 
        byte_limit > filesize GROUP BY software_binary_id;


Basically each software is assigned a "class" based on the size of its
binary into a predetermined range of classes that are defined as
relative filesizes. The above query really does work... but istm I ought
to be joining those tables somehow... any ideas? 


Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to