Re: Need help with INOUT mis-understanding - Mailing list pgsql-general

From Tom Lane
Subject Re: Need help with INOUT mis-understanding
Date
Msg-id 19208.1130425811@sss.pgh.pa.us
Whole thread Raw
In response to Re: Need help with INOUT mis-understanding  ("Troy" <troy@hendrix.biz>)
List pgsql-general
"Troy" <troy@hendrix.biz> 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why database is corrupted after re-booting
Next
From: Alex Stapleton
Date:
Subject: Re: Why database is corrupted after re-booting