>> 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.
Uh ... wait a moment ... stop the presses. Thomas is looking at
beta1 documentation. CVS HEAD handles this a bit better I think:
http://developer.
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
Tom Lane wrote:
> "Thomas H." <[EMAIL PROTECTED]> writes:
> > i saw my mistake. i misinterpreted the examples to show the possibility
> > to convert *any* text by using casting to tsvector as an alternative to
> > using to_tsvector :)
>
> Yeah, the examples in section 12.1.2 are not actually goo
"Thomas H." <[EMAIL PROTECTED]> writes:
> i saw my mistake. i misinterpreted the examples to show the possibility
> to convert *any* text by using casting to tsvector as an alternative to
> using to_tsvector :)
Yeah, the examples in section 12.1.2 are not actually good practice:
both sides of th
there are more problems with tsvectors. this also fails:
SELECT ' just a test: 123 '::tsvector;
ERROR: syntax error in tsvector: " just a test: 123 "
That's not a bug; your input isn't valid tsvector syntax.
ok. after re-reading page
http://www.postgresql.org/docs/8.3/static/textsearch-i
"Thomas H." <[EMAIL PROTECTED]> writes:
> there are more problems with tsvectors. this also fails:
> SELECT ' just a test: 123 '::tsvector;
> ERROR: syntax error in tsvector: " just a test: 123 "
That's not a bug; your input isn't valid tsvector syntax.
regards, tom lane
the reported problem below can be reproduced by using this simple query
straight from the documentation:
SELECT to_tsvector('a fat cat sat on a mat and ate a fat rat');
Works for me:
u=# set default_text_search_config = 'pg_catalog.german';
SET
u=# SELECT to_tsvector('a fat cat sat on a mat
"Thomas H." <[EMAIL PROTECTED]> writes:
> the reported problem below can be reproduced by using this simple query
> straight from the documentation:
> SELECT to_tsvector('a fat cat sat on a mat and ate a fat rat');
Works for me:
u=# set default_text_search_config = 'pg_catalog.german';
SET
u=#
the reported problem below can be reproduced by using this simple query
straight from the documentation:
SELECT to_tsvector('a fat cat sat on a mat and ate a fat rat');
--> postgres.exe dies instantly, with the logs being the same as in the
bugreport.
interestingly using ::tsvector (which