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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
