For now i am almost statisfied with my tsearch2 installation war over night
somehow it seems to work, finally...
3 probably easy questions remain...
1.) Is it possible to index already filled tables?
2.)Can i have seperated indexes for different columns in a table
3.) Can i create an extra Table just for my indexes that is not included
in my data table?
Greetings
Marcel
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org 3 1293
Marcel,
On Thu, 19 Aug 2004, Marcel Boscher wrote: For now i am almost statisfied with my tsearch2 installation war over night somehow it seems to work, finally...
what problems with installation ? Any additions,corre ctions to docs ? 3 probably easy questions remain... 1.) Is it possible to index already filled tables?
sure. It's written many times. Check to_tsvector() function
2.)Can i have seperated indexes for different columns in a table
why not, you may have separate indices or one index with different
weights assigned to each column (up tp 4 columns)
3.) Can i create an extra Table just for my indexes that is not included in my data table?
I don't understand this. Example, please.
Seems, you need to reread documentation. http://www.sai.msu.su/~megera/postgr...-V2-intro.html http://www.sai.msu.su/~megera/oddmus...earch_V2_Notes Greetings Marcel
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org
Regards,
Oleg
_______________ _______________ _______________ _______________ _
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: ol**@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org
Oleg Bartunov wrote: Marcel,
On Thu, 19 Aug 2004, Marcel Boscher wrote:
For now i am almost statisfied with my tsearch2 installation war over night somehow it seems to work, finally...
What does have tsearch2 that htdig doesn't have ( for index document I mean ) ?
Regards
Gaetano Mendola
On Thu, 19 Aug 2004, Gaetano Mendola wrote: Oleg Bartunov wrote:
Marcel,
On Thu, 19 Aug 2004, Marcel Boscher wrote:
For now i am almost statisfied with my tsearch2 installation war over night somehow it seems to work, finally... What does have tsearch2 that htdig doesn't have ( for index document I mean ) ?
Most important - index consistency and native access to document metadata.
Regards Gaetano Mendola
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
Regards,
Oleg
_______________ _______________ _______________ _______________ _
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: ol**@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: KefX |
last post by:
This may have been discussed before, but I'm kind of confused as to why Python
doesn't support having both an except ~and~ a finally clause, like this:
try:
raise RuntimeException
except:
print "What is the answer?"
finally:
print 42
|
by: Joerg Erdmenger |
last post by:
Hi there,
I have an issue with tsearch. I'm using tsearch as a search mechanism on a
website making various queries created from the words that a user has put in.
So I query for all the words put in combined with a logical 'and' and also a
query with all the words combined with a logical 'or'. In the 'and' case
stopwords are correctly...
|
by: Joerg Erdmenger |
last post by:
Hi there,
me again. How do I find the stopwords that tsearch uses in its standard
configuration? I've looked at contrib/tsearch/dict/porter_english.dct and get
a feeling it's somewhere in there but I can't decipher it. Any suggestions?
Joerg
---------------------------(end of broadcast)---------------------------
|
by: Nigel J. Andrews |
last post by:
This will be a little vague, it was last night and I can't now do the test in
that db (see below) so can't give the exact wording.
I seem to remember a report a little while ago about tsearch v2 causing
unexpected backend exit messages with 7.3.4 and now I'm getting similar
messages unpredictably and I can't find the thread in the archives...
|
by: sector119 |
last post by:
Hi
Is there some one who was able to create ukrainian or russian-urainian
stemmer dict for tsearch v2?
--
WBR, sector119
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
| |
by: Chris |
last post by:
Hi,
I am using the try catch finally block in many places in my code.
When a create an sqldatareader dr and try to close it in my
finally block I get the error: use of unsigned local variable.
dr.close();
works fine in the try but not in the finally.
|
by: Bas Scheffers |
last post by:
Hi,
Is there a way to use tsearch so that it returns documents that have less
than all the required keywords? The idea is that if a document only has 3
out of 4 terms, it is still returned, but with a lower ranking.
So far I haven't found a way to do this in the documentation. Is there
something like a "maybe" operator? (ie:...
|
by: Rajesh Kumar Mallah |
last post by:
Hi,
I think when search terms have "."s in them they become case sensitive
in tsearch searches. How can we make them insensitive?
Regds
Mallah.
|
by: linbl352 |
last post by:
Does anybody can tell me the following answers?
In the description of tsearch function, what is purpose of the callback function( compar) as follows:
void *tsearch(const void *key, void **rootp,
int(*compar)(const void *, const void *));
also, basicly what are the two parameters in the function (compar)?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |