Re: Split query
От | Katsaros Kwn/nos |
---|---|
Тема | Re: Split query |
Дата | |
Msg-id | 004901c4c0bb$30842340$e7fffbc3@NTINOAS обсуждение исходный текст |
Ответ на | Split query ("Katsaros Kwn/nos" <ntinos@aueb.gr>) |
Список | 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 >
В списке pgsql-general по дате отправления: