Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F13F89FB697 for ; Thu, 30 Aug 2007 14:27:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96800-01 for ; Thu, 30 Aug 2007 14:26:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 1EF289FB714 for ; Thu, 30 Aug 2007 14:26:59 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 10ADC3141A; Thu, 30 Aug 2007 19:26:55 +0200 (MET DST) From: Ron Mayer X-Newsgroups: pgsql.hackers Subject: Re: Why is there a tsquery data type? Date: Thu, 30 Aug 2007 10:26:45 -0700 Organization: Hub.Org Networking Services Lines: 11 Message-ID: <46D6FDD5.7080703@cheapcomplexdevices.com> References: <200708292022.l7TKMNm19553@momjian.us> <12179.1188426957@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Tom Lane User-Agent: Icedove 1.5.0.12 (X11/20070730) In-Reply-To: <12179.1188426957@sss.pgh.pa.us> To: pgsql-hackers@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/1144 X-Sequence-Number: 107066 Tom Lane wrote: > Bruce Momjian writes: >> Why does text search need a tsquery data type? I realize it needs >> tsvector so it can create indexes and updated trigger columns, but it >> seems tsquery could instead just be a simple text string. > > By that logic, we don't need any data types other than text. > Could similar logic argue that we'd want special types for regular expressions too? That seems quite parallel to the tsquery type to me.