PlPg/SQL
От
MaDog
Тема
PlPg/SQL
Дата
Msg-id
1175380856.798109.285610@b75g2000hsg.googlegroups.com
Список
Дерево обсуждения
PlPg/SQL "MaDog" <istvan.simon@gmail.com>
Re: PlPg/SQL "A. Kretschmer" <andreas.kretschmer@schollglas.com>
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?
В списке pgsql-general по дате отправления