Re: selecting a attribute from a function - Mailing list pgsql-general

On Thu, Nov 24, 2005 at 11:47:53AM +0100, A.j. Langereis wrote:
> But how can I do something like this:
>
> select my_pg_func(table2.some_col).col1
> from table2.some_col

Use another set of parentheses around the function call, as at the
end of this example:

CREATE TYPE test_type AS (col1 integer, col2 integer);

CREATE FUNCTION test_func() RETURNS test_type AS $$
DECLARE
    retval  test_type;
BEGIN
    retval.col1 := 123;
    retval.col2 := 456;
    RETURN retval;
END;
$$ LANGUAGE plpgsql;

SELECT * FROM test_func();
 col1 | col2
------+------
  123 |  456
(1 row)

SELECT (test_func()).col1;
 col1
------
  123
(1 row)

--
Michael Fuhr