Oracle Text Search Issue

From: DeB <debashish.majumdar_at_gmail.com>
Date: Mon, 20 Jul 2009 02:52:27 -0700 (PDT)
Message-ID: <28db5b5e-c87b-4668-990c-5fdbe5f1b1c8_at_h11g2000yqb.googlegroups.com>



Hi All,

   I've a table and created a Full Text index on the same as follows:

CREATE TABLE FT_TEST
(
  COL1 NUMBER(3),
  COL2 VARCHAR2(100 BYTE)
);

CREATE INDEX IDX_FT_COL2 ON FT_TEST(COL2) INDEXTYPE IS CTXSYS.CONTEXT;

INSERT INTO FT_TEST VALUES(1, 'nt=a;puc=s');
INSERT INTO FT_TEST VALUES(2, 'nt=a;puc=t');
INSERT INTO FT_TEST VALUES(3, 'nt=a;puc=a');

EXEC CTX_DDL.SYNC_INDEX('IDX_FT_COL2'); When I issue a query like -

SELECT * FROM FT_TEST WHERE CONTAINS(COL2, '{puc=s}') > 1

COL1 COL2

1	nt=a;puc=s
2	nt=a;puc=t
3	nt=a;puc=a

I was expecting to get only a single record for 'puc=s'. Am I missing any operators to achieve this? Please suggest.

--
Thanks
DeB
Received on Mon Jul 20 2009 - 04:52:27 CDT

Original text of this message