PostgreSQL - 返回键值对数组的最佳方式

PostgreSQL - 返回键值对数组的最佳方式

sql
CREATE TABLE employees (
  name VARCHAR(50),
  age INT
);
INSERT INTO employees (name, age) VALUES
  ('John Doe', 25),
  ('Jane Smith', 30),
  ('Michael Johnson', 35);

sql
CREATE OR REPLACE FUNCTION get_employee_info()
  RETURNS TABLE (employee_info TEXT[])
AS $$
DECLARE
  result RECORD;
  info TEXT[];
BEGIN
  FOR result IN SELECT name, age FROM employees LOOP
    info := ARRAY[result.name, result.age]::TEXT[];
    RETURN NEXT info;
  END LOOP;
END;
$$ LANGUAGE plpgsql;