On Mon, Oct 12, 2009 at 8:02 PM, Ivan Sergio Borgonovo wrote:
> On Mon, 12 Oct 2009 19:26:55 +0530
> Gaini Rajeshwar wrote:
>
> > Ivan,
> > If i create a tsvector as you mentioned with concatenation
> > operator, my search query will search in any of these fields which
> > are concatenated in my
On Mon, Oct 12, 2009 at 7:26 PM, Ivan Sergio Borgonovo wrote:
> On Mon, 12 Oct 2009 19:11:01 +0530
> Gaini Rajeshwar wrote:
>
> > I think you misunderstood my question. let me give clear idea
> > about what i need.
> >
> > I am using PostgreSQL fulltext search (tsearch2) feature to
> > implement
On Mon, 12 Oct 2009 19:26:55 +0530
Gaini Rajeshwar wrote:
> Ivan,
> If i create a tsvector as you mentioned with concatenation
> operator, my search query will search in any of these fields which
> are concatenated in my tsvector.
> For example, if i create tsvector like this,
> UPDATE document_t
Ivan,
If i create a tsvector as you mentioned with concatenation operator, my
search query will search in any of these fields which are concatenated in my
tsvector.
For example, if i create tsvector like this,
UPDATE document_table SET search_col =
setweight(to_tsvector(coalesce(title,'')), 'A')
On Mon, 12 Oct 2009 19:11:01 +0530
Gaini Rajeshwar wrote:
> I think you misunderstood my question. let me give clear idea
> about what i need.
>
> I am using PostgreSQL fulltext search (tsearch2) feature to
> implement searching on database. From readings i came to know that
> we can give weight
On Mon, 12 Oct 2009 18:46:02 +0530
Gaini Rajeshwar wrote:
> Hi,
> is there a way to rank the search results based on multiple fields
> in postgreSQL?
> For example,
> i have *title*, *abstract*, *summary*, *body* as fields/columns in
> my database. When user searches on *title*, i want to rank th
I think you misunderstood my question. let me give clear idea about what i
need.
I am using PostgreSQL fulltext search (tsearch2) feature to implement
searching on database. From readings i came to know that we can give weights
to different fields in database something like this:
*setweight(to_ts
On 12/10/2009 14:23, Raymond O'Donnell wrote:
> Hoe do you define "importance"?
Whoops... for "Hoe" read "How" :-)
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
r...@iol.ie
Galway Cathedral Recitals: h
On 12/10/2009 14:16, Gaini Rajeshwar wrote:
> Hi,
> is there a way to rank the search results based on multiple fields in
> postgreSQL?
> For example,
> i have *title*, *abstract*, *summary*, *body* as fields/columns in my
> database. When user searches on *title*, i want to rank the results based
Hi,
is there a way to rank the search results based on multiple fields in
postgreSQL?
For example,
i have *title*, *abstract*, *summary*, *body* as fields/columns in my
database. When user searches on *title*, i want to rank the results based on
*title* field as well as *summary* field, where impor
10 matches
Mail list logo
