开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > 查看源码
sjis.out
资源名称：postgresql-6.5.2.tar.gz　[点击查看]
上传用户：blenddy
上传日期：2007-01-07
资源大小：6495k
文件大小：4k
源码类别：

数据库系统

开发平台：

Unix_Linux

sjis.out：源码内容
  1. QUERY: drop table 寁嶼婡梡岅;
  2. QUERY: create table 寁嶼婡梡岅 (梡岅 text, 暘椶僐乕僪 varchar, 旛峫1A偩傛 char(16));
  3. QUERY: create index 寁嶼婡梡岅index1 on 寁嶼婡梡岅 using btree (梡岅);
  4. QUERY: create index 寁嶼婡梡岅index2 on 寁嶼婡梡岅 using hash (暘椶僐乕僪);
  5. QUERY: insert into 寁嶼婡梡岅 values('僐儞僺儏乕僞僨傿僗僾儗僀','婡A01忋');
  6. QUERY: insert into 寁嶼婡梡岅 values('僐儞僺儏乕僞僌儔僼傿僢僋僗','暘B10拞');
  7. QUERY: insert into 寁嶼婡梡岅 values('僐儞僺儏乕僞僾儘僌儔儅乕','恖Z01壓');
  8. QUERY: vacuum 寁嶼婡梡岅;
  9. QUERY: select * from 寁嶼婡梡岅;
  10. 梡岅                      |暘椶僐乕僪|旛峫1a偩傛
  11. --------------------------+----------+----------
  12. 僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          
  13. 僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          
  14. 僐儞僺儏乕僞僾儘僌儔儅乕  |恖Z01壓   |          
  15. (3 rows)
  17. QUERY: select * from 寁嶼婡梡岅 where 暘椶僐乕僪 = '恖Z01壓';
  18. 梡岅                    |暘椶僐乕僪|旛峫1a偩傛
  19. ------------------------+----------+----------
  20. 僐儞僺儏乕僞僾儘僌儔儅乕|恖Z01壓   |          
  21. (1 row)
  23. QUERY: select * from 寁嶼婡梡岅 where 暘椶僐乕僪 ~* '恖z01壓';
  24. 梡岅                    |暘椶僐乕僪|旛峫1a偩傛
  25. ------------------------+----------+----------
  26. 僐儞僺儏乕僞僾儘僌儔儅乕|恖Z01壓   |          
  27. (1 row)
  29. QUERY: select * from 寁嶼婡梡岅 where 暘椶僐乕僪 like '_Z01_';
  30. 梡岅                    |暘椶僐乕僪|旛峫1a偩傛
  31. ------------------------+----------+----------
  32. 僐儞僺儏乕僞僾儘僌儔儅乕|恖Z01壓   |          
  33. (1 row)
  35. QUERY: select * from 寁嶼婡梡岅 where 暘椶僐乕僪 like '_Z%';
  36. 梡岅                    |暘椶僐乕僪|旛峫1a偩傛
  37. ------------------------+----------+----------
  38. 僐儞僺儏乕僞僾儘僌儔儅乕|恖Z01壓   |          
  39. (1 row)
  41. QUERY: select * from 寁嶼婡梡岅 where 梡岅 ~ '僐儞僺儏乕僞[僨僌]';
  42. 梡岅                      |暘椶僐乕僪|旛峫1a偩傛
  43. --------------------------+----------+----------
  44. 僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          
  45. 僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          
  46. (2 rows)
  48. QUERY: select * from 寁嶼婡梡岅 where 梡岅 ~* '僐儞僺儏乕僞[僨僌]';
  49. 梡岅                      |暘椶僐乕僪|旛峫1a偩傛
  50. --------------------------+----------+----------
  51. 僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          
  52. 僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          
  53. (2 rows)
  55. QUERY: select *,character_length(梡岅) from 寁嶼婡梡岅;
  56. 梡岅                      |暘椶僐乕僪|旛峫1a偩傛|length
  57. --------------------------+----------+----------+------
  58. 僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          |    12
  59. 僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          |    13
  60. 僐儞僺儏乕僞僾儘僌儔儅乕  |恖Z01壓   |          |    12
  61. (3 rows)
  63. QUERY: select *,octet_length(梡岅) from 寁嶼婡梡岅;
  64. 梡岅                      |暘椶僐乕僪|旛峫1a偩傛|octet_length
  65. --------------------------+----------+----------+------------
  66. 僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          |          24
  67. 僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          |          26
  68. 僐儞僺儏乕僞僾儘僌儔儅乕  |恖Z01壓   |          |          24
  69. (3 rows)
  71. QUERY: select *,position('僨' in 梡岅) from 寁嶼婡梡岅;
  72. 梡岅                      |暘椶僐乕僪|旛峫1a偩傛|strpos
  73. --------------------------+----------+----------+------
  74. 僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          |     7
  75. 僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          |     0
  76. 僐儞僺儏乕僞僾儘僌儔儅乕  |恖Z01壓   |          |     0
  77. (3 rows)
  79. QUERY: select *,substring(梡岅 from 10 for 4) from 寁嶼婡梡岅;
  80. 梡岅                      |暘椶僐乕僪|旛峫1a偩傛|substr  
  81. --------------------------+----------+----------+--------
  82. 僐儞僺儏乕僞僨傿僗僾儗僀  |婡A01忋   |          |僾儗僀  
  83. 僐儞僺儏乕僞僌儔僼傿僢僋僗|暘B10拞   |          |傿僢僋僗
  84. 僐儞僺儏乕僞僾儘僌儔儅乕  |恖Z01壓   |          |儔儅乕  
  85. (3 rows)
  87. QUERY: copy 寁嶼婡梡岅 to stdout;
  88. 僐儞僺儏乕僞僨傿僗僾儗僀 婡A01忋 N
  89. 僐儞僺儏乕僞僌儔僼傿僢僋僗 暘B10拞 N
  90. 僐儞僺儏乕僞僾儘僌儔儅乕 恖Z01壓 N