Fetching a single column from a record returning function

From: "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>
To: "psql" <pgsql-sql(at)postgresql(dot)org>
Subject: Fetching a single column from a record returning function
Date: 2004-01-20 06:12:54
Message-ID: 005101c3df24$2662ed20$7502a8c0@hdsc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 the follow command

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.

Regards
kumar

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ganesan Kanavathy 2004-01-20 06:38:12 Database diagram
Previous Message V i s h a l Kashyap @ [Sai Hertz And Control Systems] 2004-01-20 05:27:23 Re: Trigger to identify which column(s) updated