Sophie

Sophie

distrib > CentOS > 5 > x86_64 > by-pkgid > eac4bf1dca5266b3284d49cb780a39d5 > files > 73

postgresql-contrib-8.1.23-10.el5_10.x86_64.rpm

DROP TABLE username_test;

CREATE TABLE username_test (
	name		text,
	username	text not null
);

CREATE TRIGGER insert_usernames
	BEFORE INSERT OR UPDATE ON username_test
	FOR EACH ROW 
	EXECUTE PROCEDURE insert_username (username);

INSERT INTO username_test VALUES ('nothing');
INSERT INTO username_test VALUES ('null', null);
INSERT INTO username_test VALUES ('empty string', '');
INSERT INTO username_test VALUES ('space', ' ');
INSERT INTO username_test VALUES ('tab', '	');
INSERT INTO username_test VALUES ('name', 'name');

SELECT * FROM username_test;