CREATE TABLE a (
	id integer,
	message varchar
);

CREATE VIEW b AS SELECT upper(message) AS msg FROM a;

INSERT INTO a VALUES (1, "Hello,");
INSERT INTO a VALUES (2, "world!");