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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
