No function matches the given name and argument types

Your function has a couple of smallint parameters.But in the call, you are using numeric literals that are presumed to be type integer. A string literal or string constant (‘123’) is not typed immediately. It remains type “unknown” until assigned or cast explicitly. However, a numeric literal or numeric constant is typed immediately. The manual: A numeric constant that contains neither a decimal … Read more