"Kumar" <[EMAIL PROTECTED]> 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,msgcount
int8,unreadcount int8,size int8);
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
