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