On Wed, 2004-07-07 at 02:04, Justin Clift wrote: > Simon Riggs wrote: > <snip> > > External tool is one thing, but the loadable personality seems like a > > very good idea and worth discussing further. > > Would an interesting, and maybe slightly different way of viewing a > "loadable personality," be as a set of "rules" that can be applied to > parser input before the parser actually gets it... and massages input > SQL into something for the parser to understand. > > I'm hugely generalising here of course, but you know how we have a > PostgreSQL "Rules" system that rewrites queries before handing them to > the query planner... well, would it be possible/practical to potentially > have a "Rules" system that rewrites incoming SQL before it gets given to > the normal parser. > > Might get complicated though... we'd need a pre-parser or something. > > However, having a generalised system for doing this may make it far > easier to provide "personalities". i.e. load a set of Oracle 8i rules, > load a set of Oracle 9i rules, load a set of DB2 x, rules, etc. > > :) >
...Something to return to later, when this release is done. Best regards, Simon ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
