2008/10/29 Tom Lane <tgl@sss.pgh.pa.us>:
> "Pavel Stehule" <pavel.stehule@gmail.com> writes:
>> I understand. So every smallint should be call with casting?
>
> A long time ago we tried to make small integer literals be interpreted
> as int2 initially, instead of int4, and the attempt failed rather
> spectacularly. (It broke most of the regression tests, IIRC, in ways
> that suggested that many client applications would have problems too.)
> Perhaps PG's type system has matured to the point where it'd work better
> now, but I'm not really interested in trying it. I don't see very much
> point in declaring functions to take smallint rather than int anyway...
I found this question on one czech it specialized site. It's mostly
beginner's problem.
regards
Pavel Stehule
>
> regards, tom lane
>