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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to