> > I am not talking about select * I am talking about
> > "select somefunc(supertable) from supertable"
> >
> > create table supertable (a int);
> > create table taba (b int) under supertable;
> >
> > create function somefunc (tup supertable) returning int
> > as 'select 1' ...
> >
> > create function somefunc (tup taba) returning int
> > as 'select 0.5*b' ....
>
> So how does this work in Informix/Illustra ?
>
> i.e. is the binding done at row evaluation time or
> "when they do 'select * ...' and don't know about coumn b"
when you do "select * from supertable" you only get column a,
but rows from both tables.
when you do select somefunc(supertable) ... the function
corresponding to the rowtype is called thus the taba rows
do get 0.5*b as result.
Andreas