Pavel Stehule <[EMAIL PROTECTED]> writes:
> the array from speed2 is ok, but array from speed is mal formated.
They both look OK to me.
> I declare all function as numeric(7,2)[]
Type modifiers applied to function arguments and results are generally
ignored. What you have here is functions returning numeric[], and not
anything else. In the plpgsql example the coercion to numeric(7,2)
happens because you stored into a local variable declared that way,
but there's nothing to make it happen in the plperl example.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
