Writing SQL functions in Postgres - Mailing list pgsql-sql

Hi,

I want to write an SQL function in postgres that returns 
row as a result.

The problem is the select statement inside the funtion has
a two table join. So I dont know what to put after SETOF

CREATE FUNCTION dummy()
RETURNS SETOF ?????
AS 'select a.name,b.cc     from tblusers   a,        tbldocs   b    where a.name=b.name'
LANGUAGE 'SQL';     


SETOF tblusers  -- doesnt work
ERROR:  function declared to return type tblusers does not retrieve
(tblusers.*)

neither does SETOF tbldocs

SETOF tblusers,tbldocs wont work either.

Anyone was able to returns a row that is a result of few table joins
inside the
function???

Regards,
Boulat Khakimov

-- 
Nothing Like the Sun