|
| 1 | +droptable computer_terms; |
| 2 | +createtablecomputer_terms(termtext, categorytext, commentschar(16)); |
| 3 | +createindexcomputer_terms_index1on computer_terms using btree(term); |
| 4 | +createindexcomputer_terms_index2on computer_terms using btree(category); |
| 5 | +insert into computer_termsvalues('computer display','X-A01-Y','a comment 1'); |
| 6 | +insert into computer_termsvalues('computer graphics','T-B01-Y','a comment 2'); |
| 7 | +insert into computer_termsvalues('computer programmer','S-Z01-Y','a comment 3'); |
| 8 | +vacuum computer_terms; |
| 9 | +select*from computer_terms; |
| 10 | +select*from computer_termswhere category='X-A01-Y'; |
| 11 | +select*from computer_termswhere category ~*'x-a01-y'; |
| 12 | +select*from computer_termswhere categorylike'_-A01-_'; |
| 13 | +select*from computer_termswhere categorylike'_-A%'; |
| 14 | +select*from computer_termswhere term ~'computer [dg]'; |
| 15 | +select*from computer_termswhere term ~*'computer [DG]'; |
| 16 | +select*,character_length(term)from computer_terms; |
| 17 | +select*,octet_length(term)from computer_terms; |
| 18 | +select*,position('s'in term)from computer_terms; |
| 19 | +select*,substring(termfrom10 for4)from computer_terms; |