SQLize Online / PHPize Online  /  SQLtest Online

DROP FUNCTION IF EXISTS select_order_name_by_id; CREATE OR REPLACE FUNCTION select_order_name_by_id(order_id INT) RETURNS TABLE(row_id INT, group_name VARCHAR(255), customer_id INT) AS $$ BEGIN WITH RECURSIVE r AS ( SELECT row_id, group_name, customer_id FROM Orders WHERE row_id = $1 UNION SELECT Orders.row_id, Orders.group_name, Orders.customer_id FROM Orders JOIN r ON Orders.parent_id = r.row_id ) SELECT row_id, group_name, customer_id FROM r LIMIT 1; RETURN r; END; $$ LANGUAGE SQL;