Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> On 8/29/12 11:40 AM, Tom Lane wrote:
>> regression=# select lpad(42,8);
> We are not seriously intending to make the above query work, are we?
Well, *I* don't want to, but apparently Robert does.
I don't really want to go much further than finding a way to handle the
"integer constant passed to smallint function argument" case. Maybe we
should consider a narrow fix for that rather than opening up the general
assignment-cast scenario.
regards, tom lane