Re: spl function returning row type?
Eric Davies wrote:
>
> Its been pointed out that my original query had a goof or two in it.
> Sadly, I cut and pasted from the wrong array of my edit buffer.
> Argghh.
> The corrected version is below, and still suffers from the described
> problem:
>
> create row type smoo ( a integer, b integer);
>
> drop function smoo2();
> create function smoo2() returning smoo;> define c smoo;
> let c.a = 3;
> let c.b = 5;
> telnet.wildstar.net 6677
> end function;
> execute function smoo2();> # ^
> # 696: Variable (c) has undefined value.
> #
I am unfamiliar with the command "create type". I presume this is a
universal server construct.
In any case, I wonder if the necessary statement might be:
return c.* ;
Just a guess..
--
-- Jake (Pondering the color of an asphyxiated smurf)
+------------------------------------------------------------+
| The expedient performance of a task with excessive concern |
| regarding its duration-to-completion engenders a virtual |
| certainty of diminished benefit therefrom. |
| -- Benjamin Franklin (but he said it in 3 words) |
+------------------------------------------------------------+