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.
:)
Regards and best wishes,
Justin Clift
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
