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* tsvector and tsquery, that'd be a fair question. I'm not 100% clear on what the differences are, but they seem pretty subtle. Do you think that having only one datatype would be clearer? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match