"Kevin Grittner" <kevin.gritt...@wicourts.gov> writes: > I realize I'm in a minority on this, but I would also prefer an error. > I expect things like > SELECT "date" + (INTERVAL '1' YEAR) > to just work.
Uh, I think you're confused. That certainly works, and I didn't hear anyone proposing to change it. The issue is about undecorated literals. If we start throwing errors for those, the fallout will make the 8.3 implicit-cast changes look like a day at the beach. I believe that it would also violate the SQL spec in numerous places --- whether you like it or not, the concept of context-dependent type resolution is built into the standard. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers