PlPg/SQL
| От | MaDog |
|---|---|
| Тема | PlPg/SQL |
| Дата | |
| Msg-id | 1175380856.798109.285610@b75g2000hsg.googlegroups.com обсуждение исходный текст |
| Ответы |
Re: PlPg/SQL
|
| Список | pgsql-general |
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 по дате отправления: