Re: Why is there a tsquery data type? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Why is there a tsquery data type?
Date
Msg-id 200708292310.l7TNAAn12960@momjian.us
Whole thread Raw
In response to Re: Why is there a tsquery data type?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Why is there a tsquery data type?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> 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.

What is tsquery giving us that text would not?

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: int8 & INT64_IS_BUSTED
Next
From: Tom Lane
Date:
Subject: Re: Representation of ResourceOwnerIds (transient XIDs) in system views (lazy xid assignment)