How to Return Table From Function - Mailing list pgsql-sql

From Rehan Saleem
Subject How to Return Table From Function
Date
Msg-id 1327237795.19340.YahooMailNeo@web121606.mail.ne1.yahoo.com
Whole thread Raw
Responses Re: How to Return Table From Function  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: How to Return Table From Function  (Rob Sargentg <robjsargent@gmail.com>)
List 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

pgsql-sql by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Token separation
Next
From: Pavel Stehule
Date:
Subject: Re: How to Return Table From Function