Re: MySQL search query is not executing in Postgres DB
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>, Andrew Dunstan <andrew@dunslane.net>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, premanand <kottiprem@gmail.com>, pgsql-hackers@postgresql.org
Date: 2012-08-27T23:13:55Z
Lists: pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes: > I agree that redefining the lexer behavior is a can of worms. What I > don't understand is why f(2+2) can't call f(smallint) when that's the > only extant f. It seems to me that we could do that without breaking > anything that works today: if you look for candidates and don't find > any, try again, allowing assignment casts the second time. Yeah, possibly. Where would you fit that in the existing sequence of tests? http://www.postgresql.org/docs/devel/static/typeconv-func.html regards, tom lane