Home > mailing lists

Fetching a single column from a record returning function - Mailing list pgsql-sql

From	Kumar
Subject	Fetching a single column from a record returning function
Date	January 20, 2004 06:14:54
Msg-id	005101c3df24$2662ed20$7502a8c0@hdsc.com Whole thread Raw
Responses	Re: Fetching a single column from a record returning function Re: Fetching a single column from a record returning function
List	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

From: "Denis"
Date: 20 January 2004, 06:00:41
Subject: Re: Database diagram

From: Roberto Mello
Date: 20 January 2004, 06:17:44
Subject: Re: Database diagram