Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group