src/test/mb/expected/sjis.out

   1 drop table ŒvŽZ‹@—pŒê;
   2 create table ŒvŽZ‹@—pŒê (—pŒê text, •ª—ÞƒR�[ƒh varchar, ”õ�l1A‚¾‚æ char(16));
   3 create index ŒvŽZ‹@—pŒêindex1 on ŒvŽZ‹@—pŒê using btree (—pŒê);
   4 create index ŒvŽZ‹@—pŒêindex2 on ŒvŽZ‹@—pŒê using hash (•ª—ÞƒR�[ƒh);
   5 insert into ŒvŽZ‹@—pŒê values('ƒRƒ“ƒsƒ…�[ƒ^ƒfƒBƒXƒvƒŒƒC','‹@A01�ã');
   6 insert into ŒvŽZ‹@—pŒê values('ƒRƒ“ƒsƒ…�[ƒ^ƒOƒ‰ƒtƒBƒbƒNƒX','•ªB10’†');
   7 insert into ŒvŽZ‹@—pŒê values('ƒRƒ“ƒsƒ…�[ƒ^ƒvƒ�ƒOƒ‰ƒ}�[','�lZ01‰º');
   8 vacuum ŒvŽZ‹@—pŒê;
   9 select * from ŒvŽZ‹@—pŒê;
  10             —pŒê            | •ª—ÞƒR�[ƒh | ”õ�l1a‚¾‚æ
  11 ----------------------------+------------+------------
  12  ƒRƒ“ƒsƒ…�[ƒ^ƒfƒBƒXƒvƒŒƒC   | ‹@A01�ã    |
  13  ƒRƒ“ƒsƒ…�[ƒ^ƒOƒ‰ƒtƒBƒbƒNƒX | •ªB10’†    |
  14  ƒRƒ“ƒsƒ…�[ƒ^ƒvƒ�ƒOƒ‰ƒ}�[   | �lZ01‰º    |
  15 (3 rows)
  16
  17 select * from ŒvŽZ‹@—pŒê where •ª—ÞƒR�[ƒh = '�lZ01‰º';
  18            —pŒê           | •ª—ÞƒR�[ƒh | ”õ�l1a‚¾‚æ
  19 --------------------------+------------+------------
  20  ƒRƒ“ƒsƒ…�[ƒ^ƒvƒ�ƒOƒ‰ƒ}�[ | �lZ01‰º    |
  21 (1 row)
  22
  23 select * from ŒvŽZ‹@—pŒê where •ª—ÞƒR�[ƒh ~* '�lz01‰º';
  24            —pŒê           | •ª—ÞƒR�[ƒh | ”õ�l1a‚¾‚æ
  25 --------------------------+------------+------------
  26  ƒRƒ“ƒsƒ…�[ƒ^ƒvƒ�ƒOƒ‰ƒ}�[ | �lZ01‰º    |
  27 (1 row)
  28
  29 select * from ŒvŽZ‹@—pŒê where •ª—ÞƒR�[ƒh like '_Z01_';
  30            —pŒê           | •ª—ÞƒR�[ƒh | ”õ�l1a‚¾‚æ
  31 --------------------------+------------+------------
  32  ƒRƒ“ƒsƒ…�[ƒ^ƒvƒ�ƒOƒ‰ƒ}�[ | �lZ01‰º    |
  33 (1 row)
  34
  35 select * from ŒvŽZ‹@—pŒê where •ª—ÞƒR�[ƒh like '_Z%';
  36            —pŒê           | •ª—ÞƒR�[ƒh | ”õ�l1a‚¾‚æ
  37 --------------------------+------------+------------
  38  ƒRƒ“ƒsƒ…�[ƒ^ƒvƒ�ƒOƒ‰ƒ}�[ | �lZ01‰º    |
  39 (1 row)
  40
  41 select * from ŒvŽZ‹@—pŒê where —pŒê ~ 'ƒRƒ“ƒsƒ…�[ƒ^[ƒfƒO]';
  42             —pŒê            | •ª—ÞƒR�[ƒh | ”õ�l1a‚¾‚æ
  43 ----------------------------+------------+------------
  44  ƒRƒ“ƒsƒ…�[ƒ^ƒfƒBƒXƒvƒŒƒC   | ‹@A01�ã    |
  45  ƒRƒ“ƒsƒ…�[ƒ^ƒOƒ‰ƒtƒBƒbƒNƒX | •ªB10’†    |
  46 (2 rows)
  47
  48 select * from ŒvŽZ‹@—pŒê where —pŒê ~* 'ƒRƒ“ƒsƒ…�[ƒ^[ƒfƒO]';
  49             —pŒê            | •ª—ÞƒR�[ƒh | ”õ�l1a‚¾‚æ
  50 ----------------------------+------------+------------
  51  ƒRƒ“ƒsƒ…�[ƒ^ƒfƒBƒXƒvƒŒƒC   | ‹@A01�ã    |
  52  ƒRƒ“ƒsƒ…�[ƒ^ƒOƒ‰ƒtƒBƒbƒNƒX | •ªB10’†    |
  53 (2 rows)
  54
  55 select *,character_length(—pŒê) from ŒvŽZ‹@—pŒê;
  56             —pŒê            | •ª—ÞƒR�[ƒh | ”õ�l1a‚¾‚æ | character_length
  57 ----------------------------+------------+------------+------------------
  58  ƒRƒ“ƒsƒ…�[ƒ^ƒfƒBƒXƒvƒŒƒC   | ‹@A01�ã    |            |               12
  59  ƒRƒ“ƒsƒ…�[ƒ^ƒOƒ‰ƒtƒBƒbƒNƒX | •ªB10’†    |            |               13
  60  ƒRƒ“ƒsƒ…�[ƒ^ƒvƒ�ƒOƒ‰ƒ}�[   | �lZ01‰º    |            |               12
  61 (3 rows)
  62
  63 select *,octet_length(—pŒê) from ŒvŽZ‹@—pŒê;
  64             —pŒê            | •ª—ÞƒR�[ƒh | ”õ�l1a‚¾‚æ | octet_length
  65 ----------------------------+------------+------------+--------------
  66  ƒRƒ“ƒsƒ…�[ƒ^ƒfƒBƒXƒvƒŒƒC   | ‹@A01�ã    |            |           24
  67  ƒRƒ“ƒsƒ…�[ƒ^ƒOƒ‰ƒtƒBƒbƒNƒX | •ªB10’†    |            |           26
  68  ƒRƒ“ƒsƒ…�[ƒ^ƒvƒ�ƒOƒ‰ƒ}�[   | �lZ01‰º    |            |           24
  69 (3 rows)
  70
  71 select *,position('ƒf' in —pŒê) from ŒvŽZ‹@—pŒê;
  72             —pŒê            | •ª—ÞƒR�[ƒh | ”õ�l1a‚¾‚æ | position
  73 ----------------------------+------------+------------+----------
  74  ƒRƒ“ƒsƒ…�[ƒ^ƒfƒBƒXƒvƒŒƒC   | ‹@A01�ã    |            |        7
  75  ƒRƒ“ƒsƒ…�[ƒ^ƒOƒ‰ƒtƒBƒbƒNƒX | •ªB10’†    |            |        0
  76  ƒRƒ“ƒsƒ…�[ƒ^ƒvƒ�ƒOƒ‰ƒ}�[   | �lZ01‰º    |            |        0
  77 (3 rows)
  78
  79 select *,substring(—pŒê from 10 for 4) from ŒvŽZ‹@—pŒê;
  80             —pŒê            | •ª—ÞƒR�[ƒh | ”õ�l1a‚¾‚æ | substring
  81 ----------------------------+------------+------------+-----------
  82  ƒRƒ“ƒsƒ…�[ƒ^ƒfƒBƒXƒvƒŒƒC   | ‹@A01�ã    |            | ƒvƒŒƒC
  83  ƒRƒ“ƒsƒ…�[ƒ^ƒOƒ‰ƒtƒBƒbƒNƒX | •ªB10’†    |            | ƒBƒbƒNƒX
  84  ƒRƒ“ƒsƒ…�[ƒ^ƒvƒ�ƒOƒ‰ƒ}�[   | �lZ01‰º    |            | ƒ‰ƒ}�[
  85 (3 rows)
  86
  87 copy ŒvŽZ‹@—pŒê to stdout;
  88 ƒRƒ“ƒsƒ…�[ƒ^ƒfƒBƒXƒvƒŒƒC        ‹@A01�ã \N
  89 ƒRƒ“ƒsƒ…�[ƒ^ƒOƒ‰ƒtƒBƒbƒNƒX      •ªB10’† \N
  90 ƒRƒ“ƒsƒ…�[ƒ^ƒvƒ�ƒOƒ‰ƒ}�[        �lZ01‰º \N