Re: OVERLOAD matching: varchar(10) & varchar(20)

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

The intention is to perform a query with diff WHERE clauses.  The
varchar(10) is order# while varchar(20) is serial#.  Personally, I'd have
just gone with diff procedures, but the original author went OVERLOAD.

Thanks



On Mon, Feb 2, 2026 at 9:03 AM Daniel Gross <daniel@xxxxxxxx> wrote:

> Well - that might help now, but it might also cause problems in the future
> when compiling programs, that depend on the first (old) prototype.
>
> With CONST one can code procedure(variable:...) or procedure('HELLO':...)
> - without CONST you can't supply the parameter as a literal.
>
> So - what is the intention of having two procedures where one parameter is
> VARCHAR(20) or VARCHAR(10)? As you had CONST, it wasn't a
> "return-parameter".
>
> HTH
> Daniel