Re: Datatypes in PL/PSQL functions with multiple arguments

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(at)archonet(dot)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
>