Boulat Khakimov <[EMAIL PROTECTED]> said:
> 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 ?
>
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,