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

From Ron Mayer
Subject Re: Why is there a tsquery data type?
Date
Msg-id 46D6FDD5.7080703@cheapcomplexdevices.com
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.
> 

Could similar logic argue that we'd want special types for regular
expressions too? That seems quite parallel to the tsquery type to me.


pgsql-hackers by date:

Previous
From: "Merlin Moncure"
Date:
Subject: enum types and binary queries
Next
From: "Florian G. Pflug"
Date:
Subject: Re: Advice on MyXactMade* flags, MyLastRecPtr, pendingDeletes and lazy XID assignment