On Tue, 22 Mar 2005, Christopher Kings-Lynne wrote: > >>ANSI SQL allows at most one OUT parameter for a function (which can be > >>used instead of having the function return a value via the usual means). > > > > OK, so that answers my question above: a single OUT parameter should be > > equated to an ordinary return value, not a RECORD, so as to emulate this > > aspect of the spec. > > Shouldn't you have the spec in one hand while designing this feature? :D
We're miles away from the spec already. For example, the spec requires that we pass the name of some variable construct, whether it be a host variable, a transition variable (ie, NEW.foo in the case of a row level trigger on a table with an attribute foo) or one of a few other less useful things, for OUT parameters. I think that not specifying OUT parameters when invoking a function is a little of confusing but it gives us a lot: its much easier to develop since we don't have to add a stack of infrastructure for host variables, for one. Gavin ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
