CREATE EXTENSION IF NOT EXISTS pg_plan_tree_dot;

CREATE TABLE employee (
       ID         int,
       name       varchar(10),
       salary     real,
       start_date date,
       city       varchar(10),
       region     char(1));

INSERT INTO employee VALUES (1,  'Jason', 40420,  '94/02/01', 'New York', 'W');
INSERT INTO employee VALUES (2,  'Robert',14420,  '95/01/02', 'Vancouver','N');
INSERT INTO employee VALUES (3,  'Celia', 24020,  '96/12/03', 'Toronto',  'W');
INSERT INTO employee VALUES (4,  'Linda', 40620,  '87/11/04', 'New York', 'N');
INSERT INTO employee VALUES (5,  'David', 80026,  '98/10/05', 'Vancouver','W');
INSERT INTO employee VALUES (6,  'James', 70060,  '99/09/06', 'Toronto',  'N');
INSERT INTO employee VALUES (7,  'Alison',90620,  '00/08/07', 'New York', 'W');
INSERT INTO employee VALUES (8,  'Chris', 26020,  '01/07/08', 'Vancouver','N');
INSERT INTO employee VALUES (9,  'Mary',  60020,  '02/06/09', 'Toronto',  'W');

CREATE FUNCTION concat_selected_fields(in_t employee) RETURNS text AS $$
BEGIN
    RETURN in_t.ID || in_t.name || in_t.city || in_t.region;
END;
$$ LANGUAGE plpgsql;

--- SELECT concat_selected_fields(employee.*) FROM employee;
SELECT generate_plan_tree_dot('SELECT concat_selected_fields(employee.*) FROM employee;', 'sample-whole-row.dot');

DROP FUNCTION concat_selected_fields(in_t employee) CASCADE;
DROP TABLE employee CASCADE;