X-Original-To: pgsql-ru-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7DDFE5350C for ; Mon, 25 Apr 2005 00:39:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78478-01 for ; Mon, 25 Apr 2005 03:39:24 +0000 (GMT) Received: from mail.perm.lo (mail.lukoilperm.ru [195.161.200.210]) by svr1.postgresql.org (Postfix) with ESMTP id 87E8D52A6B for ; Mon, 25 Apr 2005 00:38:36 -0300 (ADT) Received: from [172.30.16.173] ([127.0.0.1]) by mail.perm.lo (Netscape Messaging Server 3.6) with ESMTP id AAA2338 for ; Mon, 25 Apr 2005 09:38:24 +0600 Message-ID: <426C6626.1050903@lukoilperm.ru> Date: Mon, 25 Apr 2005 09:38:14 +0600 From: "Viktor Vislobokov" Reply-To: vvislobokov@lukoilperm.ru User-Agent: Mozilla Thunderbird 0.9 (X11/20041127) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-ru-general Subject: ILIKE =?KOI8-R?Q?=D3_=D2=D5=D3=D3=CB=C9=CD=C9_=CE=C5_=D2=C1?= =?KOI8-R?Q?=C2=CF=D4=C1=C5=D4=3F?= Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.327 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, SUBJ_ALL_CAPS X-Spam-Level: X-Archive-Number: 200504/93 X-Sequence-Number: 284 Собственно subj? Проверяю: template1=# CREATE DATABASE tmp WITH ENCODING='utf8'; CREATE DATABASE template1=# CREATE TABLE tmp_tbl (id int not null primary key, name varchar(20)); NOTICE: CREATE TABLE / PRIMARY KEY создаст подразумеваемый индекс "tmp_tbl_pkey" для таблицы "tmp_tbl" CREATE TABLE template1=# INSERT INTO tmp_tbl VALUES(1, 'Вагон'); INSERT 17182 1 template1=# SELECT * FROM tmp_tbl WHERE name ILIKE ('Ва%'); id | name ----+------------ 1 | Вагон (1 запись) template1=# select * from tmp_tbl where name ILIKE ('ва%'); id | name ----+------ (записей: 0) template1=# Есть проблема или я что-то не так делаю? -- С уважением, Виктор