insert_username.example
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:1k
- 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;