"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > It's really annoying when people save their view definition in phpPgAdmin > and when they load it up again it's lost all formatting. Functions and > rules, for instance keep the original formatting somewhere.
Rules do not. (A view is just a rule anyway.) Functions do, but that's because their definition is entered as a text string, which leads directly to those quoting headaches that you're all too familiar with. I've thought occasionally about improving the lexer so that parsetree nodes could be tagged with the section of the source text they were built from (probably in the form of a (start offset, end offset) pair). This was mainly for use in improving error reporting in the parse-analysis phase, but it might be useful for storing original source text for rules too. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]