Subject: save me from an unconstrained join
From: Robert Treat <xzilla@users.sourceforge.net>
To: pgsql-sql@postgresql.org
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Date: 30 Mar 2005 15:54:48 -0500
Message-Id: <1112216088.28936.404.camel@camel>
Mime-Version: 1.0

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