Re: SCHEMAS and procedures,...

[Vivien Malerba <malerba linuxbox com>]

On mar, 22 fév 2000, Stephan Heinze wrote:
> On Tue, 22 Feb 2000 18:47:49 Vivien Malerba wrote:
> > There is a problem: there exist some functions that have the same name
> but
> > take
> > different parameters. How can the user specify for which of these
> functions
> > he
> > wants the parameters (or we return all the parameters for all the
> functions
> > that have the given name)?
> >
> > Vivien
> 
> if your RDBMS supports this functionality there has to be a unique
> qualifier
> for the procedure ( rowids ? ) for defining the relation.
> 
> AFAIK there can only be one proc with this name in oracle.
> 

Under Postgres, each object has a unique OID (object id), so the procs have
each their id. But how can the client know that oid since it is not returned by
the SCHEMA_PROCS schema, or we introduce another colun in SCHEMA_PROCS which
gives that OID, or other under other RDBMS (which would be the cleanest way to
deal with multiple functions with the same name, along with an optionnal
constraint to specify this id)?

What do you think?

Vivien