
> > 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

Thu, 25 May 2000 18:02:06 +0200
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
AW: AW: AW: SQL3 UNDER