How to Return Table From Function

From: Rehan Saleem <pk_rehan(at)yahoo(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: How to Return Table From Function
Date: 2012-01-22 13:09:55
Message-ID: 1327237795.19340.YahooMailNeo@web121606.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hi , i have created this function

CREATE OR REPLACE FUNCTION totaloverlapcount(user_id integer , bg integer ,center_distance integer)
RETURNS varchar AS $$

DECLARE percentage record;
BEGIN

select fname, lname, count(userid) totalcount ,100.00*count(useriddetails)/totaluser into percentage
from users
where userid= user_id and bloodgroup>=bg and
(centredistance<=center_distance or center_distance=1)
group by fname, lname, user_id;
return percentage;

its just a dummy function , but all i want to know that how can i return fname , lname totalcount and percentage from this function in the form of table , not the return type varchar.
thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2012-01-22 13:53:46 Re: How to Return Table From Function
Previous Message Jasen Betts 2012-01-20 13:29:59 Re: Token separation