Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id BBC469FB311 for ; Thu, 8 Feb 2007 02:48:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 14091-03 for ; Thu, 8 Feb 2007 02:48:16 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s30.bay0.hotmail.com (bay0-omc3-s30.bay0.hotmail.com [65.54.246.230]) by postgresql.org (Postfix) with ESMTP id D72329FA5D8 for ; Thu, 8 Feb 2007 02:48:15 -0400 (AST) Received: from hotmail.com ([65.55.136.116]) by bay0-omc3-s30.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 7 Feb 2007 22:48:15 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 7 Feb 2007 22:48:14 -0800 Message-ID: Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP; Thu, 08 Feb 2007 06:48:14 GMT X-Originating-IP: [67.169.184.232] X-Originating-Email: [skarthi98@hotmail.com] X-Sender: skarthi98@hotmail.com In-Reply-To: <45C9FE04.3040908@yahoo.com.br> From: "Karthikeyan Sundaram" To: burbello3000@yahoo.com.br, pgsql-admin@postgresql.org Subject: Re: tsearch feature Date: Wed, 07 Feb 2007 22:48:14 -0800 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 08 Feb 2007 06:48:14.0791 (UTC) FILETIME=[1B6AFD70:01C74B4D] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.089 tagged_above=0 required=5 tests=AWL, BAYES_50, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/120 X-Sequence-Number: 24585 In Oracle there is something similar to tsearch2. It's called as Oracle Text. I vaguely remember the syntax. In Oracle. Select * from table where contains column = (text search) Regards skarthi >From: "Alexander B." >To: "pgsql-admin@postgresql.org" >Subject: [ADMIN] tsearch feature >Date: Wed, 07 Feb 2007 14:27:48 -0200 > >Hi, > >Sorry for my question, but what's the feature on Oracle like tsearch? >Can we consider a good difference PG under Oracle? > >Of course, PG we can developer our own application in any language. >But, talking about text search, does Oracle has a similar feature? > >Thanks > > >_______________________________________________________ >Yahoo! Mail - Sempre a melhor opção para você! >Experimente já e veja as novidades. >http://br.yahoo.com/mailbeta/tudonovo/ > > > >---------------------------(end of broadcast)--------------------------- >TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate _________________________________________________________________ Talk now to your Hotmail contacts with Windows Live Messenger. http://get.live.com/messenger/overview