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 ED8FFD1CCA8 for ; Tue, 20 Jan 2004 07:14:52 +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 44591-06 for ; Tue, 20 Jan 2004 03:14:23 -0400 (AST) Received: from smtp103.mail.sc5.yahoo.com (smtp103.mail.sc5.yahoo.com [66.163.169.222]) by svr1.postgresql.org (Postfix) with SMTP id 85B40D1CC94 for ; Tue, 20 Jan 2004 03:14:20 -0400 (AST) Received: from unknown (HELO IVESIA67) (sgnerd@203.196.190.138 with login) by smtp103.mail.sc5.yahoo.com with SMTP; 20 Jan 2004 07:14:18 -0000 Message-ID: <005101c3df24$2662ed20$7502a8c0@hdsc.com> Reply-To: "Kumar" From: "Kumar" To: "psql" Subject: Fetching a single column from a record returning function Date: Tue, 20 Jan 2004 11:42:54 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_004A_01C3DF4A.8A7BF7E0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.7 tagged_above=0.0 required=5.0 tests=HTML_40_50 X-Spam-Level: X-Archive-Number: 200401/174 X-Sequence-Number: 16567 This is a multi-part message in MIME format. ------=_NextPart_000_004A_01C3DF4A.8A7BF7E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Friends, Postgres 7.3.4 on RH Linux 7.2 I am using a record variable inside a functions and fetch the result via th= e follow command select * from .fn_email(1)=20 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. Regards kumar ------=_NextPart_000_004A_01C3DF4A.8A7BF7E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi Friends,

Postgres 7.3.4 on RH Linux 7.2

I am using a record variable inside a functions and&nbs= p;fetch=20 the result via the follow command

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

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

Regards

kumar

------=_NextPart_000_004A_01C3DF4A.8A7BF7E0--