From: Bruno Wolff III <bruno@wolff.to>
To: Christopher Dedels <cdedels@mygeotivity.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: dynamic rules?
Date: Fri, 4 Jun 2004 13:18:23 -0500
Message-ID: <20040604181823.GA20549@wolff.to> (raw)
References: <20040604161340.GA15526@wolff.to>
On Fri, Jun 04, 2004 at 09:16:04 -0700,
Christopher Dedels <cdedels@mygeotivity.com> wrote:
> Bruno,
>
> Thanks for the response.
You should keep the discussion copied to the list as long as it is on topic.
That way other people can help out.
> I was wondering if I was possible to union the tables if necessary. So, if
> I choose type=1 it selects from only the 'one' table and likewise with 2.
> However, if I query type=1 or type=2 it will union the two and return the
> results from both tables.
That is a planner issue. I suspect that currently postgres won't be able
to see that a union isn't necessary. However unless performance is a real
problem for you, you are better off using simpler code to help maintainance.
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: bruno@wolff.to, cdedels@mygeotivity.com
Subject: Re: dynamic rules?
In-Reply-To: <20040604181823.GA20549@wolff.to>
* 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