On Fri, 6 Feb 2009, James Dooley wrote:
Richard, I was refereing to the plainto_tsquery
Oleg, I only need colasque if any of those columns can be null, which is not
the case here. Correct?
yes, but for safety and generality I'd use coalesce.
Regards,
Oleg
___
Richard, I was refereing to the plainto_tsquery
Oleg, I only need colasque if any of those columns can be null, which is not
the case here. Correct?
BTW, Oleg I don't need colasque since those values can't be null.
On Fri, Feb 6, 2009 at 4:11 PM, Oleg Bartunov wrote:
> James,
>
> syntax is documented on
>
> http://www.postgresql.org/docs/8.3/static/textsearch-tables.html#TEXTSEARCH-TABLES-SEARCH
> and in the Introduction
> http://www.pos
James Dooley wrote:
>
> Now everything is working, I added my config to
>
> plainto_tsquery('my_config', 'cars')
>
> and I get results back. I find that strange though since I set the default
> to be by config, but appearantly that was just temporary and for the PID
> that changed it. Running fr
On Fri, Feb 6, 2009 at 4:01 PM, Richard Huxton wrote:
> James - don't repeat the whole of the previous message in your replies,
> trim it to the relevant part. The message is already archived on the list.
>
> James Dooley wrote:
> > Oleg, but I am only interested in whether or not the syntax of m
James,
syntax is documented on
http://www.postgresql.org/docs/8.3/static/textsearch-tables.html#TEXTSEARCH-TABLES-SEARCH
and in the Introduction
http://www.postgresql.org/docs/8.3/static/textsearch-intro.html#TEXTSEARCH-MATCHING
text-search operator was specified for tsvector @@ tsquery.
You di
James - don't repeat the whole of the previous message in your replies,
trim it to the relevant part. The message is already archived on the list.
James Dooley wrote:
> Oleg, but I am only interested in whether or not the syntax of my
> search-query is correct.
>
> Having created the index as I m
Oleg, but I am only interested in whether or not the syntax of my
search-query is correct.
Having created the index as I mentioned above, would the correct way of
searching and using that index be
... AND (title || '' || description || '' || name) @@ plainto_tsquery('car')
or should it be as Ric
James Dooley wrote:
> Hi again,
>
> I have set my configuration as default and I have created a GIN index on
> three columns, like this
>
> create index textsearch_index on products using gin(strip( to_tsvector(
> 'my_config', title || '' || description || '' || name)))
>
> Searching these colum
James,
you provide us a little useful information. If you really want help
you need to provide all information about your setup, sample queries and
explain analyze, test data illustrated your problem.
I, personally, usually prefer to have copy-pasteable information.
I think we all are quite bus
Hi again,
I have set my configuration as default and I have created a GIN index on
three columns, like this
create index textsearch_index on products using gin(strip( to_tsvector(
'my_config', title || '' || description || '' || name)))
Searching these columns the way I have
... AND (title || '
11 matches
Mail list logo
