CREATE TABLE emp $($

name text,

salary numeric,

age integer,

cubicle point

$)$; # Creates a table name emp with $4$ columns name, salary, age and cubicle

INSERT INTO emp VALUES $(\text{'}$Bill$\text{'},4200,45,\text{'}(2,1)\text{'}),(\text{'}$Jane$\text{'},4500,34,\text{'}(2,1)\text{'})$; # Inserts values into each column

CREATE FUNCTION double salary$($emp$)$ RETURNS numeric AS $$

SELECT $$1.$salary $*2$ AS salary;

$$ LANGUAGE SQL;

SELECT name, double$\_$salary$($emp$.*)$ AS dream

FROM emp

WHERE emp.cubicle ~$=$ point $\text{'}(2,1)\text{'}$;