QUERY: 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’Іј      |              
(3 rows)

QUERY: select * from ’·Ч’»»’µЎ’НС’ём where ’К¬’Оа’Ґі’Ўј’ҐЙ = '’їНZ01’Іј';
’НС’ём                              |’К¬’Оа’Ґі’Ўј’ҐЙ|’Ич’№Н1a’¤А’¤и
------------------------------------+---------------+--------------
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј|’їНZ01’Іј      |              
(1 row)

QUERY: select * from ’·Ч’»»’µЎ’НС’ём where ’К¬’Оа’Ґі’Ўј’ҐЙ ~* '’їНz01’Іј';
’НС’ём                              |’К¬’Оа’Ґі’Ўј’ҐЙ|’Ич’№Н1a’¤А’¤и
------------------------------------+---------------+--------------
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј|’їНZ01’Іј      |              
(1 row)

QUERY: select * from ’·Ч’»»’µЎ’НС’ём where ’К¬’Оа’Ґі’Ўј’ҐЙ like '_Z01_';
’НС’ём                              |’К¬’Оа’Ґі’Ўј’ҐЙ|’Ич’№Н1a’¤А’¤и
------------------------------------+---------------+--------------
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј|’їНZ01’Іј      |              
(1 row)

QUERY: select * from ’·Ч’»»’µЎ’НС’ём where ’К¬’Оа’Ґі’Ўј’ҐЙ like '_Z%';
’НС’ём                              |’К¬’Оа’Ґі’Ўј’ҐЙ|’Ич’№Н1a’¤А’¤и
------------------------------------+---------------+--------------
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј|’їНZ01’Іј      |              
(1 row)

QUERY: select * from ’·Ч’»»’µЎ’НС’ём where ’НС’ём ~ '’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї[’ҐЗ’Ґ°]';
’НС’ём                                 |’К¬’Оа’Ґі’Ўј’ҐЙ|’Ич’№Н1a’¤А’¤и
---------------------------------------+---------------+--------------
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤   |’µЎA01’ѕе      |              
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№|’К¬B10’Гж      |              
(2 rows)

QUERY: select * from ’·Ч’»»’µЎ’НС’ём where ’НС’ём ~* '’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї[’ҐЗ’Ґ°]';
’НС’ём                                 |’К¬’Оа’Ґі’Ўј’ҐЙ|’Ич’№Н1a’¤А’¤и
---------------------------------------+---------------+--------------
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤   |’µЎA01’ѕе      |              
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№|’К¬B10’Гж      |              
(2 rows)

QUERY: select *,character_length(’НС’ём) from ’·Ч’»»’µЎ’НС’ём;
’НС’ём                                 |’К¬’Оа’Ґі’Ўј’ҐЙ|’Ич’№Н1a’¤А’¤и|length
---------------------------------------+---------------+--------------+------
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤   |’µЎA01’ѕе      |              |    12
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№|’К¬B10’Гж      |              |    13
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј   |’їНZ01’Іј      |              |    12
(3 rows)

QUERY: select *,octet_length(’НС’ём) from ’·Ч’»»’µЎ’НС’ём;
’НС’ём                                 |’К¬’Оа’Ґі’Ўј’ҐЙ|’Ич’№Н1a’¤А’¤и|octet_length
---------------------------------------+---------------+--------------+------------
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤   |’µЎA01’ѕе      |              |          36
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№|’К¬B10’Гж      |              |          39
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј   |’їНZ01’Іј      |              |          36
(3 rows)

QUERY: select *,position('’ҐЗ' in ’НС’ём) from ’·Ч’»»’µЎ’НС’ём;
’НС’ём                                 |’К¬’Оа’Ґі’Ўј’ҐЙ|’Ич’№Н1a’¤А’¤и|strpos
---------------------------------------+---------------+--------------+------
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤   |’µЎA01’ѕе      |              |     7
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№|’К¬B10’Гж      |              |     0
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј   |’їНZ01’Іј      |              |     0
(3 rows)

QUERY: select *,substring(’НС’ём from 10 for 4) from ’·Ч’»»’µЎ’НС’ём;
’НС’ём                                 |’К¬’Оа’Ґі’Ўј’ҐЙ|’Ич’№Н1a’¤А’¤и|substr      
---------------------------------------+---------------+--------------+------------
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤   |’µЎA01’ѕе      |              |’ҐЧ’Ґм’Ґ¤   
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№|’К¬B10’Гж      |              |’ҐЈ’ҐГ’ҐЇ’Ґ№
’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј   |’їНZ01’Іј      |              |’Ґй’ҐЮ’Ўј   
(3 rows)

QUERY: 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‘ПВ|        
(3 rows)

QUERY: select * from ‘јЖ‘Лг‘»ъ‘Кх‘Уп where ‘·Ц‘Аа‘єЕ = '‘ИЛZ01‘ПВ';
‘Кх‘Уп         |‘·Ц‘Аа‘єЕ|‘±ё‘Чў1a
---------------+---------+--------
‘µз‘ДФ‘іМ‘Рт‘Ф±|‘ИЛZ01‘ПВ|        
(1 row)

QUERY: select * from ‘јЖ‘Лг‘»ъ‘Кх‘Уп where ‘·Ц‘Аа‘єЕ ~* '‘ИЛz01‘ПВ';
‘Кх‘Уп         |‘·Ц‘Аа‘єЕ|‘±ё‘Чў1a
---------------+---------+--------
‘µз‘ДФ‘іМ‘Рт‘Ф±|‘ИЛZ01‘ПВ|        
(1 row)

QUERY: select * from ‘јЖ‘Лг‘»ъ‘Кх‘Уп where ‘·Ц‘Аа‘єЕ like '_Z01_';
‘Кх‘Уп         |‘·Ц‘Аа‘єЕ|‘±ё‘Чў1a
---------------+---------+--------
‘µз‘ДФ‘іМ‘Рт‘Ф±|‘ИЛZ01‘ПВ|        
(1 row)

QUERY: select * from ‘јЖ‘Лг‘»ъ‘Кх‘Уп where ‘·Ц‘Аа‘єЕ like '_Z%';
‘Кх‘Уп         |‘·Ц‘Аа‘єЕ|‘±ё‘Чў1a
---------------+---------+--------
‘µз‘ДФ‘іМ‘Рт‘Ф±|‘ИЛZ01‘ПВ|        
(1 row)

QUERY: select * from ‘јЖ‘Лг‘»ъ‘Кх‘Уп where ‘Кх‘Уп ~ '‘µз‘ДФ[‘ПФ‘Нј]';
‘Кх‘Уп         |‘·Ц‘Аа‘єЕ|‘±ё‘Чў1a
---------------+---------+--------
‘µз‘ДФ‘ПФ‘Кѕ‘ЖБ|‘»ъA01‘ЙП|        
‘µз‘ДФ‘Нј‘РО   |‘·ЦB01‘ЦР|        
(2 rows)

QUERY: select * from ‘јЖ‘Лг‘»ъ‘Кх‘Уп where ‘Кх‘Уп ~* '‘µз‘ДФ[‘ПФ‘Нј]';
‘Кх‘Уп         |‘·Ц‘Аа‘єЕ|‘±ё‘Чў1a
---------------+---------+--------
‘µз‘ДФ‘ПФ‘Кѕ‘ЖБ|‘»ъA01‘ЙП|        
‘µз‘ДФ‘Нј‘РО   |‘·ЦB01‘ЦР|        
(2 rows)

QUERY: select *,character_length(‘Кх‘Уп) from ‘јЖ‘Лг‘»ъ‘Кх‘Уп;
‘Кх‘Уп         |‘·Ц‘Аа‘єЕ|‘±ё‘Чў1a|length
---------------+---------+--------+------
‘µз‘ДФ‘ПФ‘Кѕ‘ЖБ|‘»ъA01‘ЙП|        |     5
‘µз‘ДФ‘Нј‘РО   |‘·ЦB01‘ЦР|        |     4
‘µз‘ДФ‘іМ‘Рт‘Ф±|‘ИЛZ01‘ПВ|        |     5
(3 rows)

QUERY: select *,octet_length(‘Кх‘Уп) from ‘јЖ‘Лг‘»ъ‘Кх‘Уп;
‘Кх‘Уп         |‘·Ц‘Аа‘єЕ|‘±ё‘Чў1a|octet_length
---------------+---------+--------+------------
‘µз‘ДФ‘ПФ‘Кѕ‘ЖБ|‘»ъA01‘ЙП|        |          15
‘µз‘ДФ‘Нј‘РО   |‘·ЦB01‘ЦР|        |          12
‘µз‘ДФ‘іМ‘Рт‘Ф±|‘ИЛZ01‘ПВ|        |          15
(3 rows)

QUERY: 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‘ПВ|        |‘іМ‘Рт‘Ф±
(3 rows)

QUERY: 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“щ»   |              
(3 rows)

QUERY: select * from “НЄ“Я©“С¦“їл“ѕо where “ЭВ“Чѕ“ДЪ“µе = '“мСZ01“щ»';
“їл“ѕо                  |“ЭВ“Чѕ“ДЪ“µе|“єс“°н1a“¶у“±ё
------------------------+------------+--------------
“ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ|“мСZ01“щ»   |              
(1 row)

QUERY: select * from “НЄ“Я©“С¦“їл“ѕо where “ЭВ“Чѕ“ДЪ“µе ~* '“мСz01“щ»';
“їл“ѕо                  |“ЭВ“Чѕ“ДЪ“µе|“єс“°н1a“¶у“±ё
------------------------+------------+--------------
“ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ|“мСZ01“щ»   |              
(1 row)

QUERY: select * from “НЄ“Я©“С¦“їл“ѕо where “ЭВ“Чѕ“ДЪ“µе like '_Z01_';
“їл“ѕо                  |“ЭВ“Чѕ“ДЪ“µе|“єс“°н1a“¶у“±ё
------------------------+------------+--------------
“ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ|“мСZ01“щ»   |              
(1 row)

QUERY: select * from “НЄ“Я©“С¦“їл“ѕо where “ЭВ“Чѕ“ДЪ“µе like '_Z%';
“їл“ѕо                  |“ЭВ“Чѕ“ДЪ“µе|“єс“°н1a“¶у“±ё
------------------------+------------+--------------
“ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ|“мСZ01“щ»   |              
(1 row)

QUERY: select * from “НЄ“Я©“С¦“їл“ѕо where “їл“ѕо ~ '“ДД“З»“ЕН[“µр“±Ч]';
“їл“ѕо                  |“ЭВ“Чѕ“ДЪ“µе|“єс“°н1a“¶у“±ё
------------------------+------------+--------------
“ДД“З»“ЕН“µр“Ѕє“ЗГ“·№“АМ|“С¦A01“Яѕ   |              
“ДД“З»“ЕН“±Ч“·Ў“ЗИ“Ѕє   |“ЭВB10“сй   |              
(2 rows)

QUERY: select * from “НЄ“Я©“С¦“їл“ѕо where “їл“ѕо ~* '“ДД“З»“ЕН[“µр“±Ч]';
“їл“ѕо                  |“ЭВ“Чѕ“ДЪ“µе|“єс“°н1a“¶у“±ё
------------------------+------------+--------------
“ДД“З»“ЕН“µр“Ѕє“ЗГ“·№“АМ|“С¦A01“Яѕ   |              
“ДД“З»“ЕН“±Ч“·Ў“ЗИ“Ѕє   |“ЭВB10“сй   |              
(2 rows)

QUERY: select *,character_length(“їл“ѕо) from “НЄ“Я©“С¦“їл“ѕо;
“їл“ѕо                  |“ЭВ“Чѕ“ДЪ“µе|“єс“°н1a“¶у“±ё|length
------------------------+------------+--------------+------
“ДД“З»“ЕН“µр“Ѕє“ЗГ“·№“АМ|“С¦A01“Яѕ   |              |     8
“ДД“З»“ЕН“±Ч“·Ў“ЗИ“Ѕє   |“ЭВB10“сй   |              |     7
“ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ|“мСZ01“щ»   |              |     8
(3 rows)

QUERY: select *,octet_length(“їл“ѕо) from “НЄ“Я©“С¦“їл“ѕо;
“їл“ѕо                  |“ЭВ“Чѕ“ДЪ“µе|“єс“°н1a“¶у“±ё|octet_length
------------------------+------------+--------------+------------
“ДД“З»“ЕН“µр“Ѕє“ЗГ“·№“АМ|“С¦A01“Яѕ   |              |          24
“ДД“З»“ЕН“±Ч“·Ў“ЗИ“Ѕє   |“ЭВB10“сй   |              |          21
“ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ|“мСZ01“щ»   |              |          24
(3 rows)

QUERY: 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“щ»   |              |“ЕН“ЗБ“·О“±Ч
(3 rows)

QUERY: drop table test;
ERROR:  Relation test Does Not Exist!
QUERY: create table test (t text);
QUERY: insert into test values('ENGLISH');
QUERY: insert into test values('FRANЃЗAIS');
QUERY: insert into test values('ESPAЃСOL');
QUERY: insert into test values('ЃНSLENSKA');
QUERY: insert into test values('ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA');
QUERY: vacuum test;
QUERY: select * from test;
t                                   
------------------------------------
ENGLISH                             
FRANЃЗAIS                           
ESPAЃСOL                            
ЃНSLENSKA                           
ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA
(5 rows)

QUERY: select * from test where t = 'ESPAЃСOL';
t       
--------
ESPAЃСOL
(1 row)

QUERY: select * from test where t ~* 'espaЃСol';
t                                   
------------------------------------
ESPAЃСOL                            
ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA
(2 rows)

QUERY: select *,character_length(t) from test;
t                                   |length
------------------------------------+------
ENGLISH                             |     7
FRANЃЗAIS                           |     8
ESPAЃСOL                            |     7
ЃНSLENSKA                           |     8
ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA|    33
(5 rows)

QUERY: select *,octet_length(t) from test;
t                                   |octet_length
------------------------------------+------------
ENGLISH                             |           7
FRANЃЗAIS                           |           9
ESPAЃСOL                            |           8
ЃНSLENSKA                           |           9
ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA|          36
(5 rows)

QUERY: select *,position('L' in t) from test;
t                                   |strpos
------------------------------------+------
ENGLISH                             |     4
FRANЃЗAIS                           |     0
ESPAЃСOL                            |     7
ЃНSLENSKA                           |     3
ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA|     4
(5 rows)

QUERY: select *,substring(t from 3 for 4) from test;
t                                   |substr
------------------------------------+------
ENGLISH                             |GLIS  
FRANЃЗAIS                           |ANЃЗA 
ESPAЃСOL                            |PAЃСO 
ЃНSLENSKA                           |LENS  
ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA|GLIS  
(5 rows)