Re: Fetching a single column from a record returning function - Mailing list pgsql-sql

"Kumar" <sgnerd@yahoo.com.sg> writes:
> select * from fn_email(1)
> as (email_folder_id int4,email_folder_name varchar,descrip varchar,msgcount
>  int8,unreadcount int8,size int8);

> Is it possible to fetch only one column (the 'msgcount') from the function.=
>  Because I am interested in SUM(msgcount).  Please shed some light.

select sum(msgcount) from fn_email(1)
as (email_folder_id int4,email_folder_name varchar,descrip varchar,msgcountint8,unreadcount int8,size int8);
        regards, tom lane