Fix multibyte regress results for EUC_CN, EUC_KR and EUC_TW

3 files changed, 190 insertions, 190 deletions

diff --git a/src/test/regress/expected/euc_cn.out b/src/test/regress/expected/euc_cn.out
index b9944f48fd8..37790f83b85 100644
--- a/src/test/regress/expected/euc_cn.out
+++ b/src/test/regress/expected/euc_cn.out
@@ -1,87 +1,87 @@
-QUERY: drop table 计算机术语;
+drop table 计算机术语;
 ERROR:  Relation '计算机术语' does not exist
-QUERY: create table 计算机术语(术语 text, 分类号 varchar, 备注1A char(16));
-QUERY: create index 计算机术语index1 on 计算机术语 using btree(术语);
-QUERY: create index 计算机术语index2 on 计算机术语 using btree(分类号);
-QUERY: insert into 计算机术语 values('电脑显示屏','机A01上');
-QUERY: insert into 计算机术语 values('电脑图形','分B01中');
-QUERY: insert into 计算机术语 values('电脑程序员','人Z01下');
-QUERY: vacuum 计算机术语;
-QUERY: select * from 计算机术语;
-术语      |分类号 |备注1a
-----------+-------+------
-电脑显示屏|机A01上|      
-电脑图形  |分B01中|      
-电脑程序员|人Z01下|      
+create table 计算机术语(术语 text, 分类号 varchar, 备注1A char(16));
+create index 计算机术语index1 on 计算机术语 using btree(术语);
+create index 计算机术语index2 on 计算机术语 using btree(分类号);
+insert into 计算机术语 values('电脑显示屏','机A01上');
+insert into 计算机术语 values('电脑图形','分B01中');
+insert into 计算机术语 values('电脑程序员','人Z01下');
+vacuum 计算机术语;
+select * from 计算机术语;
+    术语    | 分类号  | 备注1a 
+------------+---------+--------
+ 电脑显示屏 | 机A01上 | 
+ 电脑图形   | 分B01中 | 
+ 电脑程序员 | 人Z01下 | 
 (3 rows)
 
-QUERY: select * from 计算机术语 where 分类号 = '人Z01下';
-术语      |分类号 |备注1a
-----------+-------+------
-电脑程序员|人Z01下|      
+select * from 计算机术语 where 分类号 = '人Z01下';
+    术语    | 分类号  | 备注1a 
+------------+---------+--------
+ 电脑程序员 | 人Z01下 | 
 (1 row)
 
-QUERY: select * from 计算机术语 where 分类号 ~* '人z01下';
-术语      |分类号 |备注1a
-----------+-------+------
-电脑程序员|人Z01下|      
+select * from 计算机术语 where 分类号 ~* '人z01下';
+    术语    | 分类号  | 备注1a 
+------------+---------+--------
+ 电脑程序员 | 人Z01下 | 
 (1 row)
 
-QUERY: select * from 计算机术语 where 分类号 like '_Z01_';
-术语      |分类号 |备注1a
-----------+-------+------
-电脑程序员|人Z01下|      
+select * from 计算机术语 where 分类号 like '_Z01_';
+    术语    | 分类号  | 备注1a 
+------------+---------+--------
+ 电脑程序员 | 人Z01下 | 
 (1 row)
 
-QUERY: select * from 计算机术语 where 分类号 like '_Z%';
-术语      |分类号 |备注1a
-----------+-------+------
-电脑程序员|人Z01下|      
+select * from 计算机术语 where 分类号 like '_Z%';
+    术语    | 分类号  | 备注1a 
+------------+---------+--------
+ 电脑程序员 | 人Z01下 | 
 (1 row)
 
-QUERY: select * from 计算机术语 where 术语 ~ '电脑[显图]';
-术语      |分类号 |备注1a
-----------+-------+------
-电脑显示屏|机A01上|      
-电脑图形  |分B01中|      
+select * from 计算机术语 where 术语 ~ '电脑[显图]';
+    术语    | 分类号  | 备注1a 
+------------+---------+--------
+ 电脑显示屏 | 机A01上 | 
+ 电脑图形   | 分B01中 | 
 (2 rows)
 
-QUERY: select * from 计算机术语 where 术语 ~* '电脑[显图]';
-术语      |分类号 |备注1a
-----------+-------+------
-电脑显示屏|机A01上|      
-电脑图形  |分B01中|      
+select * from 计算机术语 where 术语 ~* '电脑[显图]';
+    术语    | 分类号  | 备注1a 
+------------+---------+--------
+ 电脑显示屏 | 机A01上 | 
+ 电脑图形   | 分B01中 | 
 (2 rows)
 
-QUERY: select *,character_length(术语) from 计算机术语;
-术语      |分类号 |备注1a|length
-----------+-------+------+------
-电脑显示屏|机A01上|      |     5
-电脑图形  |分B01中|      |     4
-电脑程序员|人Z01下|      |     5
+select *,character_length(术语) from 计算机术语;
+    术语    | 分类号  | 备注1a | length 
+------------+---------+--------+--------
+ 电脑显示屏 | 机A01上 |        |      5
+ 电脑图形   | 分B01中 |        |      4
+ 电脑程序员 | 人Z01下 |        |      5
 (3 rows)
 
-QUERY: select *,octet_length(术语) from 计算机术语;
-术语      |分类号 |备注1a|octet_length
-----------+-------+------+------------
-电脑显示屏|机A01上|      |          10
-电脑图形  |分B01中|      |           8
-电脑程序员|人Z01下|      |          10
+select *,octet_length(术语) from 计算机术语;
+    术语    | 分类号  | 备注1a | octet_length 
+------------+---------+--------+--------------
+ 电脑显示屏 | 机A01上 |        |           10
+ 电脑图形   | 分B01中 |        |            8
+ 电脑程序员 | 人Z01下 |        |           10
 (3 rows)
 
-QUERY: select *,position('显' in 术语) from 计算机术语;
-术语      |分类号 |备注1a|strpos
-----------+-------+------+------
-电脑显示屏|机A01上|      |     3
-电脑图形  |分B01中|      |     0
-电脑程序员|人Z01下|      |     0
+select *,position('显' in 术语) from 计算机术语;
+    术语    | 分类号  | 备注1a | strpos 
+------------+---------+--------+--------
+ 电脑显示屏 | 机A01上 |        |      3
+ 电脑图形   | 分B01中 |        |      0
+ 电脑程序员 | 人Z01下 |        |      0
 (3 rows)
 
-QUERY: select *,substring(术语 from 3 for 4) from 计算机术语;
-术语      |分类号 |备注1a|substr
-----------+-------+------+------
-电脑显示屏|机A01上|      |显示屏
-电脑图形  |分B01中|      |图形  
-电脑程序员|人Z01下|      |程序员
+select *,substring(术语 from 3 for 4) from 计算机术语;
+    术语    | 分类号  | 备注1a | substr 
+------------+---------+--------+--------
+ 电脑显示屏 | 机A01上 |        | 显示屏
+ 电脑图形   | 分B01中 |        | 图形
+ 电脑程序员 | 人Z01下 |        | 程序员
 (3 rows)
 
diff --git a/src/test/regress/expected/euc_kr.out b/src/test/regress/expected/euc_kr.out
index 9d3ca8ce3dd..4c91395ab1f 100644
--- a/src/test/regress/expected/euc_kr.out
+++ b/src/test/regress/expected/euc_kr.out
@@ -1,87 +1,87 @@
-QUERY: drop table 酮擤薛侩绢;
+drop table 酮擤薛侩绢;
 ERROR:  Relation '酮擤薛侩绢' does not exist
-QUERY: create table 酮擤薛侩绢 (侩绢 text, 萋拙内靛 varchar, 厚绊1A扼备 char(16));
-QUERY: create index 酮擤薛侩绢index1 on 酮擤薛侩绢 using btree (侩绢);
-QUERY: create index 酮擤薛侩绢index2 on 酮擤薛侩绢 using hash (萋拙内靛);
-QUERY: insert into 酮擤薛侩绢 values('哪腔磐叼胶敲饭捞', '薛A01呔');
-QUERY: insert into 酮擤薛侩绢 values('哪腔磐弊贰侨胶', '萋B10耖');
-QUERY: insert into 酮擤薛侩绢 values('哪腔磐橇肺弊贰赣', '煅Z01');
-QUERY: vacuum 酮擤薛侩绢;
-QUERY: select * from 酮擤薛侩绢;
-侩绢            |萋拙内靛|厚绊1a扼备
-----------------+--------+----------
-哪腔磐叼胶敲饭捞|薛A01呔 |          
-哪腔磐弊贰侨胶  |萋B10耖 |          
-哪腔磐橇肺弊贰赣|煅Z01 |          
+create table 酮擤薛侩绢 (侩绢 text, 萋拙内靛 varchar, 厚绊1A扼备 char(16));
+create index 酮擤薛侩绢index1 on 酮擤薛侩绢 using btree (侩绢);
+create index 酮擤薛侩绢index2 on 酮擤薛侩绢 using hash (萋拙内靛);
+insert into 酮擤薛侩绢 values('哪腔磐叼胶敲饭捞', '薛A01呔');
+insert into 酮擤薛侩绢 values('哪腔磐弊贰侨胶', '萋B10耖');
+insert into 酮擤薛侩绢 values('哪腔磐橇肺弊贰赣', '煅Z01');
+vacuum 酮擤薛侩绢;
+select * from 酮擤薛侩绢;
+       侩绢       | 萋拙内靛 | 厚绊1a扼备 
+------------------+----------+------------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔  | 
+ 哪腔磐弊贰侨胶   | 萋B10耖  | 
+ 哪腔磐橇肺弊贰赣 | 煅Z01  | 
 (3 rows)
 
-QUERY: select * from 酮擤薛侩绢 where 萋拙内靛 = '煅Z01';
-侩绢            |萋拙内靛|厚绊1a扼备
-----------------+--------+----------
-哪腔磐橇肺弊贰赣|煅Z01 |          
+select * from 酮擤薛侩绢 where 萋拙内靛 = '煅Z01';
+       侩绢       | 萋拙内靛 | 厚绊1a扼备 
+------------------+----------+------------
+ 哪腔磐橇肺弊贰赣 | 煅Z01  | 
 (1 row)
 
-QUERY: select * from 酮擤薛侩绢 where 萋拙内靛 ~* '煅z01';
-侩绢            |萋拙内靛|厚绊1a扼备
-----------------+--------+----------
-哪腔磐橇肺弊贰赣|煅Z01 |          
+select * from 酮擤薛侩绢 where 萋拙内靛 ~* '煅z01';
+       侩绢       | 萋拙内靛 | 厚绊1a扼备 
+------------------+----------+------------
+ 哪腔磐橇肺弊贰赣 | 煅Z01  | 
 (1 row)
 
-QUERY: select * from 酮擤薛侩绢 where 萋拙内靛 like '_Z01_';
-侩绢            |萋拙内靛|厚绊1a扼备
-----------------+--------+----------
-哪腔磐橇肺弊贰赣|煅Z01 |          
+select * from 酮擤薛侩绢 where 萋拙内靛 like '_Z01_';
+       侩绢       | 萋拙内靛 | 厚绊1a扼备 
+------------------+----------+------------
+ 哪腔磐橇肺弊贰赣 | 煅Z01  | 
 (1 row)
 
-QUERY: select * from 酮擤薛侩绢 where 萋拙内靛 like '_Z%';
-侩绢            |萋拙内靛|厚绊1a扼备
-----------------+--------+----------
-哪腔磐橇肺弊贰赣|煅Z01 |          
+select * from 酮擤薛侩绢 where 萋拙内靛 like '_Z%';
+       侩绢       | 萋拙内靛 | 厚绊1a扼备 
+------------------+----------+------------
+ 哪腔磐橇肺弊贰赣 | 煅Z01  | 
 (1 row)
 
-QUERY: select * from 酮擤薛侩绢 where 侩绢 ~ '哪腔磐[叼弊]';
-侩绢            |萋拙内靛|厚绊1a扼备
-----------------+--------+----------
-哪腔磐叼胶敲饭捞|薛A01呔 |          
-哪腔磐弊贰侨胶  |萋B10耖 |          
+select * from 酮擤薛侩绢 where 侩绢 ~ '哪腔磐[叼弊]';
+       侩绢       | 萋拙内靛 | 厚绊1a扼备 
+------------------+----------+------------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔  | 
+ 哪腔磐弊贰侨胶   | 萋B10耖  | 
 (2 rows)
 
-QUERY: select * from 酮擤薛侩绢 where 侩绢 ~* '哪腔磐[叼弊]';
-侩绢            |萋拙内靛|厚绊1a扼备
-----------------+--------+----------
-哪腔磐叼胶敲饭捞|薛A01呔 |          
-哪腔磐弊贰侨胶  |萋B10耖 |          
+select * from 酮擤薛侩绢 where 侩绢 ~* '哪腔磐[叼弊]';
+       侩绢       | 萋拙内靛 | 厚绊1a扼备 
+------------------+----------+------------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔  | 
+ 哪腔磐弊贰侨胶   | 萋B10耖  | 
 (2 rows)
 
-QUERY: select *,character_length(侩绢) from 酮擤薛侩绢;
-侩绢            |萋拙内靛|厚绊1a扼备|length
-----------------+--------+----------+------
-哪腔磐叼胶敲饭捞|薛A01呔 |          |     8
-哪腔磐弊贰侨胶  |萋B10耖 |          |     7
-哪腔磐橇肺弊贰赣|煅Z01 |          |     8
+select *,character_length(侩绢) from 酮擤薛侩绢;
+       侩绢       | 萋拙内靛 | 厚绊1a扼备 | length 
+------------------+----------+------------+--------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔  |            |      8
+ 哪腔磐弊贰侨胶   | 萋B10耖  |            |      7
+ 哪腔磐橇肺弊贰赣 | 煅Z01  |            |      8
 (3 rows)
 
-QUERY: select *,octet_length(侩绢) from 酮擤薛侩绢;
-侩绢            |萋拙内靛|厚绊1a扼备|octet_length
-----------------+--------+----------+------------
-哪腔磐叼胶敲饭捞|薛A01呔 |          |          16
-哪腔磐弊贰侨胶  |萋B10耖 |          |          14
-哪腔磐橇肺弊贰赣|煅Z01 |          |          16
+select *,octet_length(侩绢) from 酮擤薛侩绢;
+       侩绢       | 萋拙内靛 | 厚绊1a扼备 | octet_length 
+------------------+----------+------------+--------------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔  |            |           16
+ 哪腔磐弊贰侨胶   | 萋B10耖  |            |           14
+ 哪腔磐橇肺弊贰赣 | 煅Z01  |            |           16
 (3 rows)
 
-QUERY: select *,position('叼' in 侩绢) from 酮擤薛侩绢;
-侩绢            |萋拙内靛|厚绊1a扼备|strpos
-----------------+--------+----------+------
-哪腔磐叼胶敲饭捞|薛A01呔 |          |     4
-哪腔磐弊贰侨胶  |萋B10耖 |          |     0
-哪腔磐橇肺弊贰赣|煅Z01 |          |     0
+select *,position('叼' in 侩绢) from 酮擤薛侩绢;
+       侩绢       | 萋拙内靛 | 厚绊1a扼备 | strpos 
+------------------+----------+------------+--------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔  |            |      4
+ 哪腔磐弊贰侨胶   | 萋B10耖  |            |      0
+ 哪腔磐橇肺弊贰赣 | 煅Z01  |            |      0
 (3 rows)
 
-QUERY: select *,substring(侩绢 from 3 for 4) from 酮擤薛侩绢;
-侩绢            |萋拙内靛|厚绊1a扼备|substr  
-----------------+--------+----------+--------
-哪腔磐叼胶敲饭捞|薛A01呔 |          |磐叼胶敲
-哪腔磐弊贰侨胶  |萋B10耖 |          |磐弊贰侨
-哪腔磐橇肺弊贰赣|煅Z01 |          |磐橇肺弊
+select *,substring(侩绢 from 3 for 4) from 酮擤薛侩绢;
+       侩绢       | 萋拙内靛 | 厚绊1a扼备 |  substr  
+------------------+----------+------------+----------
+ 哪腔磐叼胶敲饭捞 | 薛A01呔  |            | 磐叼胶敲
+ 哪腔磐弊贰侨胶   | 萋B10耖  |            | 磐弊贰侨
+ 哪腔磐橇肺弊贰赣 | 煅Z01  |            | 磐橇肺弊
 (3 rows)
 
diff --git a/src/test/regress/expected/euc_tw.out b/src/test/regress/expected/euc_tw.out
index a7d2b940695..c35ee9509d7 100644
--- a/src/test/regress/expected/euc_tw.out
+++ b/src/test/regress/expected/euc_tw.out
@@ -1,85 +1,85 @@
-QUERY: drop table 燹俑骜砧;
+drop table 燹俑骜砧;
 ERROR:  Relation '燹俑骜砧' does not exist
-QUERY: create table 燹俑骜砧 (如淦杀 text, 狞瞥婉螭 varchar, 氢蛇 varchar(16));
-QUERY: create index 燹俑骜砧index1 on 燹俑骜砧 using btree (如淦杀);
-QUERY: create index 燹俑骜砧index2 on 燹俑骜砧 using hash (狞瞥婉螭);
-QUERY: insert into 燹俑骜砧 values ('缳妾淦', '绠绠绎世', '啤A01念');
-QUERY: insert into 燹俑骜砧 values ('犒葸淦', '芈溷却宇狞瞥', '你B10你');
-QUERY: insert into 燹俑骜砧 values ('螫悖淦', '印汤洗枪却宇狞瞥', '仨Z01摩');
-QUERY: vacuum 燹俑骜砧;
-QUERY: select * from 燹俑骜砧;
-如淦杀|狞瞥婉螭        |氢蛇   
-------+----------------+-------
-缳妾淦|绠绠绎世        |啤A01念
-犒葸淦|芈溷却宇狞瞥    |你B10你
-螫悖淦|印汤洗枪却宇狞瞥|仨Z01摩
+create table 燹俑骜砧 (如淦杀 text, 狞瞥婉螭 varchar, 氢蛇 varchar(16));
+create index 燹俑骜砧index1 on 燹俑骜砧 using btree (如淦杀);
+create index 燹俑骜砧index2 on 燹俑骜砧 using hash (狞瞥婉螭);
+insert into 燹俑骜砧 values ('缳妾淦', '绠绠绎世', '啤A01念');
+insert into 燹俑骜砧 values ('犒葸淦', '芈溷却宇狞瞥', '你B10你');
+insert into 燹俑骜砧 values ('螫悖淦', '印汤洗枪却宇狞瞥', '仨Z01摩');
+vacuum 燹俑骜砧;
+select * from 燹俑骜砧;
+ 如淦杀 |     狞瞥婉螭     |  氢蛇   
+--------+------------------+---------
+ 缳妾淦 | 绠绠绎世         | 啤A01念
+ 犒葸淦 | 芈溷却宇狞瞥     | 你B10你
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
 (3 rows)
 
-QUERY: select * from 燹俑骜砧 where 氢蛇 = '仨Z01摩';
-如淦杀|狞瞥婉螭        |氢蛇   
-------+----------------+-------
-螫悖淦|印汤洗枪却宇狞瞥|仨Z01摩
+select * from 燹俑骜砧 where 氢蛇 = '仨Z01摩';
+ 如淦杀 |     狞瞥婉螭     |  氢蛇   
+--------+------------------+---------
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
 (1 row)
 
-QUERY: select * from 燹俑骜砧 where 氢蛇 ~* '仨z01摩';
-如淦杀|狞瞥婉螭        |氢蛇   
-------+----------------+-------
-螫悖淦|印汤洗枪却宇狞瞥|仨Z01摩
+select * from 燹俑骜砧 where 氢蛇 ~* '仨z01摩';
+ 如淦杀 |     狞瞥婉螭     |  氢蛇   
+--------+------------------+---------
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
 (1 row)
 
-QUERY: select * from 燹俑骜砧 where 氢蛇 like '_Z01_';
-如淦杀|狞瞥婉螭        |氢蛇   
-------+----------------+-------
-螫悖淦|印汤洗枪却宇狞瞥|仨Z01摩
+select * from 燹俑骜砧 where 氢蛇 like '_Z01_';
+ 如淦杀 |     狞瞥婉螭     |  氢蛇   
+--------+------------------+---------
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
 (1 row)
 
-QUERY: select * from 燹俑骜砧 where 氢蛇 like '_Z%';
-如淦杀|狞瞥婉螭        |氢蛇   
-------+----------------+-------
-螫悖淦|印汤洗枪却宇狞瞥|仨Z01摩
+select * from 燹俑骜砧 where 氢蛇 like '_Z%';
+ 如淦杀 |     狞瞥婉螭     |  氢蛇   
+--------+------------------+---------
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩
 (1 row)
 
-QUERY: select * from 燹俑骜砧 where 狞瞥婉螭 ~ '绠绠绎[凫卮世]';
-如淦杀|狞瞥婉螭|氢蛇   
-------+--------+-------
-缳妾淦|绠绠绎世|啤A01念
+select * from 燹俑骜砧 where 狞瞥婉螭 ~ '绠绠绎[凫卮世]';
+ 如淦杀 | 狞瞥婉螭 |  氢蛇   
+--------+----------+---------
+ 缳妾淦 | 绠绠绎世 | 啤A01念
 (1 row)
 
-QUERY: select * from 燹俑骜砧 where 狞瞥婉螭 ~* '绠绠绎[凫卮世]';
-如淦杀|狞瞥婉螭|氢蛇   
-------+--------+-------
-缳妾淦|绠绠绎世|啤A01念
+select * from 燹俑骜砧 where 狞瞥婉螭 ~* '绠绠绎[凫卮世]';
+ 如淦杀 | 狞瞥婉螭 |  氢蛇   
+--------+----------+---------
+ 缳妾淦 | 绠绠绎世 | 啤A01念
 (1 row)
 
-QUERY: select *, character_length(如淦杀) from 燹俑骜砧;
-如淦杀|狞瞥婉螭        |氢蛇   |length
-------+----------------+-------+------
-缳妾淦|绠绠绎世        |啤A01念|     3
-犒葸淦|芈溷却宇狞瞥    |你B10你|     3
-螫悖淦|印汤洗枪却宇狞瞥|仨Z01摩|     3
+select *, character_length(如淦杀) from 燹俑骜砧;
+ 如淦杀 |     狞瞥婉螭     |  氢蛇   | length 
+--------+------------------+---------+--------
+ 缳妾淦 | 绠绠绎世         | 啤A01念 |      3
+ 犒葸淦 | 芈溷却宇狞瞥     | 你B10你 |      3
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩 |      3
 (3 rows)
 
-QUERY: select *, octet_length(如淦杀) from 燹俑骜砧;
-如淦杀|狞瞥婉螭        |氢蛇   |octet_length
-------+----------------+-------+------------
-缳妾淦|绠绠绎世        |啤A01念|           6
-犒葸淦|芈溷却宇狞瞥    |你B10你|           6
-螫悖淦|印汤洗枪却宇狞瞥|仨Z01摩|           6
+select *, octet_length(如淦杀) from 燹俑骜砧;
+ 如淦杀 |     狞瞥婉螭     |  氢蛇   | octet_length 
+--------+------------------+---------+--------------
+ 缳妾淦 | 绠绠绎世         | 啤A01念 |            6
+ 犒葸淦 | 芈溷却宇狞瞥     | 你B10你 |            6
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩 |            6
 (3 rows)
 
-QUERY: select *, position('却宇' in 狞瞥婉螭) from 燹俑骜砧;
-如淦杀|狞瞥婉螭        |氢蛇   |strpos
-------+----------------+-------+------
-缳妾淦|绠绠绎世        |啤A01念|     0
-犒葸淦|芈溷却宇狞瞥    |你B10你|     3
-螫悖淦|印汤洗枪却宇狞瞥|仨Z01摩|     5
+select *, position('却宇' in 狞瞥婉螭) from 燹俑骜砧;
+ 如淦杀 |     狞瞥婉螭     |  氢蛇   | strpos 
+--------+------------------+---------+--------
+ 缳妾淦 | 绠绠绎世         | 啤A01念 |      0
+ 犒葸淦 | 芈溷却宇狞瞥     | 你B10你 |      3
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩 |      5
 (3 rows)
 
-QUERY: select *, substring(狞瞥婉螭 from 3 for 6 ) from 燹俑骜砧;
-如淦杀|狞瞥婉螭        |氢蛇   |substr      
-------+----------------+-------+------------
-缳妾淦|绠绠绎世        |啤A01念|绎世        
-犒葸淦|芈溷却宇狞瞥    |你B10你|却宇狞瞥    
-螫悖淦|印汤洗枪却宇狞瞥|仨Z01摩|洗枪却宇狞瞥
+select *, substring(狞瞥婉螭 from 3 for 6 ) from 燹俑骜砧;
+ 如淦杀 |     狞瞥婉螭     |  氢蛇   |    substr    
+--------+------------------+---------+--------------
+ 缳妾淦 | 绠绠绎世         | 啤A01念 | 绎世
+ 犒葸淦 | 芈溷却宇狞瞥     | 你B10你 | 却宇狞瞥
+ 螫悖淦 | 印汤洗枪却宇狞瞥 | 仨Z01摩 | 洗枪却宇狞瞥
 (3 rows)