Then I guess I need to know how one can encapsulate variables in quotes, yet let the pl/pgsql interpreter interpolate.
In the case of my SELECT INTO, are the quotes even needed to avoid potential confusion with column names?
On 4/19/05, Richard Huxton < dev@archonet.com> wrote: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