Received: from smail-12.hanmail.net ([211.233.30.161]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1AAKkx36591 for ; Sat, 10 Feb 2001 05:20:46 -0500 (EST) (envelope-from spbear@hanmail.net) Received: from www5.hanmail.net (www5.hanmail.net [211.32.117.25]) by smail-12.hanmail.net (8.10.0/8.9.1) with ESMTP id f1AA0sN30421; Sat, 10 Feb 2001 19:00:54 +0900 Received: (from hanadmin@localhost) by www5.hanmail.net (8.10.0/8.9.1) id f1A9x7E14080; Sat, 10 Feb 2001 18:59:07 +0900 (KST) X-Originating-IP: [203.253.24.54] From: "Kim Yunhan" Reply-To: "Kim Yunhan" Organization: Soongsil Univ. To: pgsql-sql@postgresql.org Subject: How to make operator class? X-Mailer: Daum Web Mailer 1.0 Date: Sat, 10 Feb 2001 18:59:07 KST Message-Id: <20010210185907.HM.40000000001W64L@www5.hanmail.net> Errors-To: MIME-Version: 1.0 Content-Type: text/plain; charset=euc-kr Content-Transfer-Encoding: 8bit X-Archive-Number: 200102/191 X-Sequence-Number: 1378 when create indexes, use operator class like this. CREATE INDEX idx_name ON tbl_name (col_name [operator class]); so, i made an operator. but i think that it is different operator class because operator class doesn't work at all. then, how to make operator class? ================================================== ================================================== 우리 인터넷, Daum 평생 쓰는 무료 E-mail 주소 한메일넷 지구촌 한글 검색서비스 Daum FIREBALL http://www.daum.net