Re: Function Parameter Problem

fathur rohman <fathur_edp@yahoo.com> writes:
> i'v finished creating function generate_sjno(str_no
> char(12), int_reset int2).
> when it called an error message raised, this is the
> illustration:

> baisdb=> select generate_sjno('20060130',6);
> ERROR:  function generate_sjno("unknown", integer)
> does not exist

It's not the char argument that's giving you trouble there, it's the int2.
I'd strongly suggest declaring the function to take plain int, else
you're going to be writing a lot of downcasts to int2.  int->int2 is not
an implicit conversion.

            regards, tom lane