On Mon, 2006-04-24 at 14:57 +0200, Frank Schönheit - Sun Microsystems Germany wrote: > Hi Andrew, > > > It seems obvious to me that having a query as part of a query > > is just a matter of making the parser accept sub-selects. > > Not completely. "Stored" sub selects (be it as view or as query) have > the advantage that they can be edited independently from the "outer" > query, and re-used in different other queries. Especially the latter is > an important facet of the whole feature, which I think we don't want to > lose.
I saw the fact that they must be "stored" more as a necessity of the graphical editing environment - although being able to reuse them as if they are "views" is obviously useful. However, how they are presented to the DBMS is important. They will be expanded and presented as sub- selects presumably, so that the DBMS can apply it's own analysis and optimisations. Or is there another method in mind? Ross --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
