Hello,
we upgraded our PostgreSQL from 7.2 to 7.4, because we want to use the
enhanced full-text searches,
which should be build in now.
I can't find any informations how to implement an optimized search in the
docs ....
Today the search feels like " fieldvarchar30 ~* '^VALUESTRING.* ' " ,
is the full text search based on special indizes, a special table type or
whatever ?
A link to start search would be fine,
bye,
Andre Gellert
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org 2  2111 
On Monday 08 December 2003 10:31, Gellert, Andre wrote: Hello,
we upgraded our PostgreSQL from 7.2 to 7.4, because we want to use the
enhanced full-text searches,
which should be build in now.
I can't find any informations how to implement an optimized search in the
docs ....
Today the search feels like " fieldvarchar30 ~* '^VALUESTRING.* ' " ,
is the full text search based on special indizes, a special table type or
whatever ? http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
hth
Ian Barwick ba*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly
contrib/tsearch2 might helps you.
Oleg
On Mon, 8 Dec 2003, Gellert, Andre wrote: Hello,
we upgraded our PostgreSQL from 7.2 to 7.4, because we want to use the
enhanced full-text searches,
which should be build in now.
I can't find any informations how to implement an optimized search in the
docs ....
Today the search feels like " fieldvarchar30 ~* '^VALUESTRING.* ' " ,
is the full text search based on special indizes, a special table type or
whatever ?
A link to start search would be fine,
bye,
Andre Gellert
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.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 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Bosconian |
last post by:
I have a client that provides a list of companies on their web site (powered
by PHP/MySQL.) These companies advertise their services to visitors. The
company information has been maintained exclusively by the client, but now
they would like to provide a way for the companies to update their own
information.
Can someone suggest a reasonable secure method to allow the companies to
edit their own information without a login and...
|
by: David Pautler |
last post by:
I'm creating a web-based authoring tool where one form encompasses
several sections for editing. I'd like each section to have its own
reset button, so that use of that button affects only that section.
I can't find anything in the 4.0 spec about how to do this, and the
only mention in this group I found is from 1998 below (CERN blocked my
email to Alan).
I've tried wrapping each section in its own fieldset, but that had no
effect.
|
by: Adam Hearn |
last post by:
Sorry if this difficult to understand but I'm pulling my hair out and could
do with some good ideas please...
I've developed an application which in .NET as a Windows service which is
simply crashing but with no signs/details on where the crash is occuring.
Please not that the crash is happening on the server and only when the
server is running on a Win2K3 host. App is developed as an N-Tier app
(client-processing-processing-data) with...
|
by: Tor Erik Sønvisen |
last post by:
Hi
I need to browse the socket-module source-code. I believe it's contained in
the file socketmodule.c, but I can't locate this file... Where should I
look?
regards tores
|
by: BookerW |
last post by:
Ok interesting, on my local machine
And i did not do a good job of keeping track of the exact order....
but on my local machine
in which i have vis studio 2003 installed and IIS for win XP,
I copied the web.config file from the source code folder into the
inetpub\wwwroot folder b/c that is where the ASP engine was looking for it.
| | |
by: rdemyan via AccessMonster.com |
last post by:
I'm trying to implement a licensing scheme. There are three types of
licenses:
Trial - good for 30 to 60 days
Interim - good for 1 year
Fully Paid - no expiration
Everything is working fine and I've even implemented a registration system
where the users can upgrade by just receiving a code from me.
|
by: ijoxley |
last post by:
Hi
I'm in the middle of implementing ASP.NET membership and role-based
authentication using the new ASP.NET 2.0 Membership and Roles
classes/database and was stuck on the following:
When using the Security Setup Wizard to add rules for directory access
based on the roles I have created, where do these rules get stored?
I had assumed that this was being written to the application's
|
by: Java Guy |
last post by:
I can find a lot of stuff on the internet about javascript, except how
to I determine which version my IE6 is compatible with, or where to
download javascript plugin/engine/what-ever for Windows (windows 98 se
specifically).
Basically, I don't write java or javascript code, but I want to update
or tweak or fix how IE is handling javascript on my system currently.
Where do I get that "stuff" ???
|
by: Emin |
last post by:
Dear Experts,
I have a fairly simple query in which adding a where clause slows
things down by at least a factor of 100. The following is the slow
version of the query
-------------------------
SELECT * FROM
( Select x.event_date From x FULL OUTER JOIN y
ON x.event_date = y.event_date
|
by: blackduck603 |
last post by:
Hi,
I am fairly new to Access programming and Reports. I have inherited a project and am trying to understand some of the inner workings. There is a field named Overall in the Detail section of my report. The Control source for this field is SumOfbalance (and no - I did NOT forget to capitalize the b in balance). After a good deal of digging, I managed to find a reference to this field in a query in the VB code associated with this report. A...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
