This is actually already possible.

select ( select result from min_date(d_one, d_two)) from two_dates;

What I had in mind was something like this:

EXECUTE PROCEDURE MYPROC <param list>
SELECT <column list> FROM ATABLE

and for each record in ATABLE it would plug in the parameters for MYPROC and
execute the procedure.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Adam Clarke" <Adam.Clarke@...>
To: <IB-Architect@yahoogroups.com>
Sent: Friday, February 09, 2001 7:50 PM
Subject: Re: [IB-Architect] proc directory type information tables


> Like this?
>
> select min_date(d_one, d_two) from two_dates;
>
> where min_date is a stored proc.
>
> I'll take one.
>
> Cheers
> Adam
>
> ----- Original Message -----
> From: "Jason Wharton" <jwharton@...>
> To: <IB-Architect@yahoogroups.com>
> Sent: Saturday, February 10, 2001 1:24 PM
> Subject: Re: [IB-Architect] proc directory type information tables
>
>
> > > In short, being able to update from a select would be
> > > a good thing.
> >
> > So would being able to execute a proc from a select be a good thing.
> >
> > Output of the select would go to the input of the proc...
> >
> > Seems I got in trouble for asking for this a while ago so save your
breath
> > this time OK?
> >
> > FWIW,
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > IB-Architect-unsubscribe@onelist.com
> >
> >
> >
> >
>
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com
>
>
>