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

From A.j. Langereis
Subject selecting a attribute from a function
Date
Msg-id 006201c5f0ee$affe52d0$3e01a8c0@aarjan2
Whole thread Raw
Responses Re: selecting a attribute from a function  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
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(table2.some_col).col1
from table2.some_col
 
Yours,
 
Aarjan

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Private email requests
Next
From: Adam Witney
Date:
Subject: Re: "invalid page header in block 597621 of relation..."error