Re: Why is there a tsquery data type?

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Why is there a tsquery data type?
Date: 2007-08-30 17:26:45
Message-ID: 46D6FDD5.7080703@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Florian G. Pflug 2007-08-30 17:31:23 Re: Advice on MyXactMade* flags, MyLastRecPtr, pendingDeletes and lazy XID assignment
Previous Message Merlin Moncure 2007-08-30 17:13:17 enum types and binary queries