Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> I'm not sure that putting in to_tsvector calls there would be an
>> improvement, though, since at that point we haven't introduced
>> to_tsvector.
>>
>> Thoughts anyone?
> Yep, I saw that chicken and egg problem in the docs when I was reviewing
> it long ago. I never came up with a solution either.
OTOH, I see that the very next sentence mentions to_tsquery without
defining it. So maybe it wouldn't be materially less readable if we
just changed the examples to use to_tsquery and to_tsvector instead
of literal-casting. Either way, there is something going on that
doesn't meet the eye, and we might as well write an example that is
actually OK practice rather than bad practice.
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
