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

Kumar wrote:
> 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.


What's wrong with:

select msgcount from fn_email(1)
as (email_folder_id int4,email_folder_name varchar,descrip 
varchar,msgcount int8,unreadcount int8,size int8);

?

Try showing us more detail about what you want to do and why it isn't 
currently working.

Joe