Added to TODO:
* Consider a special data type for regular expressions
http://archives.postgresql.org/pgsql-hackers/2007-08/msg01067.php
---
Tom Lane wrote:
> Ron Mayer <[EMAIL PROTECTED]> writes:
> > Could similar logic
Ron Mayer <[EMAIL PROTECTED]> writes:
> Could similar logic argue that we'd want special types for regular
> expressions too? That seems quite parallel to the tsquery type to me.
Yeah, it certainly seems like something we might want to consider in
future --- we could get rid of that klugy cache fo
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> 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 a
On Thu, 30 Aug 2007, Bruce Momjian wrote:
Gregory Stark wrote:
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
There is no question things would be clearer with only one text search
data type. The only value I can see to having a tsquery data type is
that you can store a tsquery value in a colum
Tom Lane wrote:
> Gregory Stark <[EMAIL PROTECTED]> writes:
> > How would that happen if there wasn't a tsquery type?
>
> I don't think Bruce is suggesting that the search operand can really
> be plain text (or if he is, he's nuts). The question here is whether
Yes, that is what I was suggesting
Gregory Stark <[EMAIL PROTECTED]> writes:
> How would that happen if there wasn't a tsquery type?
I don't think Bruce is suggesting that the search operand can really
be plain text (or if he is, he's nuts). The question here is whether
there's really a need for a distinction between tsvector and
Gregory Stark wrote:
> "Bruce Momjian" <[EMAIL PROTECTED]> writes:
>
> > Gregory Stark wrote:
> >> "Bruce Momjian" <[EMAIL PROTECTED]> writes:
> >>
> >> > There is no question things would be clearer with only one text search
> >> > data type. The only value I can see to having a tsquery data ty
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
> Gregory Stark wrote:
>> "Bruce Momjian" <[EMAIL PROTECTED]> writes:
>>
>> > There is no question things would be clearer with only one text search
>> > data type. The only value I can see to having a tsquery data type is
>> > that you can store a tsq
Gregory Stark wrote:
> "Bruce Momjian" <[EMAIL PROTECTED]> writes:
>
> > There is no question things would be clearer with only one text search
> > data type. The only value I can see to having a tsquery data type is
> > that you can store a tsquery value in a column, but why would that be
> > mu
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
> There is no question things would be clearer with only one text search
> data type. The only value I can see to having a tsquery data type is
> that you can store a tsquery value in a column, but why would that be
> much better than just storing it in
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> By that logic, we don't need any data types other than text.
>
> > What is tsquery giving us that text would not?
>
> A preprocessed representation that can be compared to tsvector
> efficiently.
>
> Now, if you
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> By that logic, we don't need any data types other than text.
> What is tsquery giving us that text would not?
A preprocessed representation that can be compared to tsvector
efficiently.
Now, if you'd asked whether we need *both* tsve
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> 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 nee
Bruce Momjian <[EMAIL PROTECTED]> 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
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.
--
Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us
EnterpriseDB
15 matches
Mail list logo