Re: [SQL] Writing SQL functions in Postgres

2001-03-08 Thread dev
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 ? >

[SQL] Writing SQL functions in Postgres

2001-03-08 Thread Boulat Khakimov
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,