X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1746AD1CB56 for ; Tue, 20 Jan 2004 15:58:32 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 56069-02 for ; Tue, 20 Jan 2004 11:58:05 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id B88DAD1B47D for ; Tue, 20 Jan 2004 11:58:00 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id i0KFw5pH024271; Tue, 20 Jan 2004 10:58:05 -0500 (EST) To: "Kumar" Cc: "psql" Subject: Re: Fetching a single column from a record returning function In-reply-to: <005101c3df24$2662ed20$7502a8c0@hdsc.com> References: <005101c3df24$2662ed20$7502a8c0@hdsc.com> Comments: In-reply-to "Kumar" message dated "Tue, 20 Jan 2004 11:42:54 +0530" Date: Tue, 20 Jan 2004 10:58:04 -0500 Message-ID: <24270.1074614284@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/186 X-Sequence-Number: 16579 "Kumar" 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