Re: Datatypes in PL/PSQL functions with multiple arguments

Benjamin Holmberg wrote:
>
> This is the error message I'm getting by using: ''arg_id'' instead of:
> (CAST(arg_id
> AS integer))
> SELECT production_scheduled_for_date('2005-05-12', '49');
> ERROR: invalid input syntax for integer: "arg_id"

That's because ''arg_id'' is the string value "arg_id", those six
characters rather than the value of any variable.

--
   Richard Huxton
   Archonet Ltd