From: Oz <x_download@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Searching for results with an unknown amount of data
Date: Fri, 2 Sep 2005 22:27:07 +0100
Message-ID: <BAY101-DAV1617F72B18EE9D28B97922FCA30@phx.gbl> (raw)
Hi,
I've got two tables, A and B, the first one containing columns
A_ID | info
where A_ID is primary, so that this table stores various information about
an object, and the second containing columns
A_ID | property
where property is an integer referring to a particular property that an
object may possess. I've seperated these into two tables so that an object
may have several (ie an unknown number of) properties.
Now, I want to find all objects that have at most properties 1,2,3, say (so
something with (1,2) is okay, as is (1,2,3)). I can't see a way to do this
-- can anyone help?
Also, what if I want to find all the objects possessing properties 4,5,6, as
well as possibly other things? I've done it with nested SELECTs (constructed
programmatically), but I think this is quite slow and not a very pleasing
solution.
Obviously, both these things will need to be done for an arbitrary list of
integers.
Thanks,
DL
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: x_download@hotmail.com
Subject: Re: Searching for results with an unknown amount of data
In-Reply-To: <BAY101-DAV1617F72B18EE9D28B97922FCA30@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox