On Nov 9, 2007 5:14 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Todd A. Cook" <[EMAIL PROTECTED]> writes: > > I saw the item in the release notes about the new "return query" > > syntax in pl/pgsql, but I didn't see any note about "query" being > > reserved now. Perhaps an explicit mention should be added? > > Yeah, I got burnt by that too. I have a bad feeling that that keyword > is going to cause trouble for a lot of people. > > [ thinks for a bit... ] It might be possible to get rid of the keyword > and have RETURN QUERY be recognized by an ad-hoc strcmp test, much like > the various direction keywords in FETCH have been handled without making > them real keywords. It'd be a bit uglier but it'd avoid making QUERY > be effectively a reserved word.
It's not uncommon to have auditing triggers store things in tables with fields named query in them. I know I have a few places that do this... Just sayin' ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
