Re: [GENERAL] Need help with INOUT mis-understanding

[Tom Lane]

"Troy" <[EMAIL PROTECTED]> writes:
> P.S. - Tom if the return of func2 = var_X = (10,5) how can I parse the
> varible out like:
> var_Y = var_X[1] -- first ARRAY item
> to get var_Y = 10?

Try assigning the function result to a RECORD variable, perhaps

        SELECT * INTO rec FROM foo(...);

Then you can access the record variable's fields.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend