Re: Bug #939: Function parameter of type int2 fail when called. - Mailing list pgsql-bugs

pgsql-bugs@postgresql.org writes:
> In version 7.2 we defined a bunch of functions with parameters of type int2.  In version 7.2 this worked as
advertised. We then upgraded to version 7.3.2.  After upgrading we were not able to run any functions that had the int2
typeas a parameter.  When we tried to run one of those functions we got the following error message: 

If you are calling the function with a simple literal constant, you need
to cast the constant to int2 explicitly; downconversion from int4 to
int2 is not automatic anymore.

            regards, tom lane