"Tom Lane" <[EMAIL PROTECTED]> writes: > I was somewhat bemused just now to find that this function stopped > working: > > regression=# create function estimate_rows(query text) returns float8 as $$ ... > This works fine in 8.2. The reason it no longer works is that "query" > is now a special token in the plpgsql lexer, and that means that it will > never be substituted for by read_sql_construct(). So it's effectively > a reserved word.
Perhaps we should be throwing a more intelligible error if you have a parameter (or variable?) named in a way that will conflict? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match