Re: [GENERAL] selecting a attribute from a function

2005-11-29 Thread Michael Fuhr
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 intege

[GENERAL] selecting a attribute from a function

2005-11-24 Thread A.j. Langereis
Dear all, I have written a function that returns a set. This set is of a type I made, containing multiple attributes.   create type my_type as (col1 int, col2 int)   Something likes this works:   select col1 from my_pg_func('hello');   But how can I do something like this:   select my_pg_func(t