Hi!
How can i return one more row form a pgpl/sql function?
CREATE OR REPLACE FUNCTION GetRows(INTEGER, INTEGER, INTEGER) RETURNS
TEXT AS $$
DECLARE
Rows table_name%ROWTYPE;
BEGIN
SELECT * INTO Rows FROM table1_name WHERE id = $1;
-- Return (1, 'Smis', '[EMAIL PROTECTED]')
SELECT * INTO Rows FROM table2_name WHERE id = $2;
-- Return (2, 'Ashle', '[EMAIL PROTECTED]')
SELECT * INTO Rows FROM table3_name WHERE id = $3;
-- Return (1, 'Galaxy University', '[EMAIL PROTECTED]')
RETURN Rows;
END;
$$ LANGUAGE 'plpgsql';
SELECT * FROM GetRows(1,2,3);
I want return for all 3 row in one table? How can i do that?
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
