gistfile1.txt

CREATE OR REPLACE FUNCTION match_order (
	left_id int
) RETURNS int AS $$
DECLARE
	left "order"%ROWTYPE;
	right "order"%ROWTYPE;
	price bigint;
BEGIN
	SELECT * INTO left FROM "order" o WHERE o.order_id = left_id;

	SELECT * INTO right FROM "order" o		
	WHERE 
		o.have = left.want AND
		o.want = left.have
	ORDER BY
		o.price ASC, o.created ASC;	
	
	RETURN NULL;
END; $$ LANGUAGE plpgsql;