Search Postgresql Archives

Re: Need help with INOUT mis-understanding

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Troy" <troy@xxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux