mirror of https://github.com/postgres/postgres
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
22 lines
562 B
22 lines
562 B
28 years ago
|
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;
|
||
|
|
|