Stored Procedures and Return Type - Mailing list pgsql-novice

Hello,

What would be the rtype for a function to return tuples selected over more
than one table?  The closest I can find is setof but this rtype is for all
columns of only one table.

Example:

states
state_id integer
state_name varchar
state_abbreviation char(2)

districts
district_id integer
state_id integer
district_name varchar


CREATE OR REPLACE FUNCTION districts(varchar, varchar) RETURNS ???? AS '
    SELECT state_name, districtname FROM states s, districts d
    WHERE s.state_id = d.state_id AND s.state_name = $1 AND d.district_name = $2;
' LANGUAGE 'sql';