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', 'smis@gmail.com')
SELECT * INTO Rows FROM table2_name WHERE id = $2;
-- Return (2, 'Ashle', 'Ashle@gmail.com')
SELECT * INTO Rows FROM table3_name WHERE id = $3;
-- Return (1, 'Galaxy University', 'g-uni@gmail.com')
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?