Re: Split query

From: "Katsaros Kwn/nos" <ntinos(at)aueb(dot)gr>
To: "Tino Wildenhain" <tino(at)wildenhain(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Split query
Date: 2004-11-02 09:05:34
Message-ID: 004901c4c0bb$30842340$e7fffbc3@NTINOAS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Well, the second question is trivial indeed :-) ,even though I had
pipelining in mind when writting it...
(which is not so query oriented but rather plan/executor oriented)
However, I'm more interested in the first question.

Thank you very much,
Ntinos

Tino Wildenhain wrote:
> Hi,
>
> On Tue, 2004-11-02 at 07:47, Katsaros Kwn/nos wrote:
> > Hi!
> >
> > I want to parse a query (SFW) and create new queries: one for each
> > table referenced, if that possible.
> > I've written a function for this in the Query struct level after
> > parse&rewrite (not very general ofcourse :-)) but I would like to
> > know whether there is any code written for this purpose at any level.
> > Are there any algorithms for this?
> > Following, is there any code or at least some algorithm about merging
> > the individual results returned from these queries?
>
> The latter is easy. Consider:
>
> SELECT ... FROM
> (SELECT ... first query here) AS table_a
> JOIN
> (SELECT ... second query here) AS table_b
> USING (same_column);
>
> (or ON table_a.column = table_b.column)
>
> I dont think you should think about joining results
> outside the database. You have Postgresql here, remember :-)
>
> Regards
> Tino
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2004-11-02 09:05:38 Re: Subselect Question
Previous Message Einar Már Björvinsson 2004-11-02 09:00:58