I try to enable "fuzzystrmatch" function in Postgresql 8.3.9, following is my solution:
- DO NOT install Postgresql under the default "Progrem File" directory, because the it can't not recognize the white space inside the path! I switch to some directory not containing while space, like "C:\PostgreSQL\8.3\". I will use this as my Postgres home directory. I install and reinstall several times and figure out this isssue. Actually. it is a very common problem using software ported form Linux world.
- You will find lots of DLL files under "lib". But we should go to "share\contrib" directory. Run:
-
C:\PostgreSQL\8.3\bin>psql -d postgres -U postgres -f C:\PostgreSQL\8.3\share\contrib\fuzzystrmatch.sql
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
- You should note that this funtion must be specified to any database you want. It is not a global setting! Then try SELECT levenshtein('GUMBO', 'GAMBOL');
or SELECT name FROM element WHERE difference(name, 'item') > 2;
- If you want to check out more fuzzy search, go to reference [1]. There will be another solution, please refer to [2].
- Next, I will try xml and full-text search functions.
Reference:
[1]http://www.postgresql.org/docs/8.3/static/fuzzystrmatch.html
[2]http://stackoverflow.com/questions/430123/how-do-i-enable-the-postgresql-function-profiler
[3] FAQ on installation for Windows: http://wiki.postgresql.org/wiki/Running_&_Installing_PostgreSQL_On_Native_Windows
[4] Thanks this page poniting out the right location for the sql file: http://dcmms.sourceforge.net/doc/administration/index.html#fuzzystrmatch_manual_install
分享到:
相关推荐
PRWIN98.HLP Online help for Mask for Windows - PRWin98. PRWIN98.LIC License Agreement for Mask for Windows - PRWin98. TOOLHELP.DLL Windows' tool-helper functions module. README.TXT General ...
dbExpress is a database-independent layer that defines common interface to provide fast access to Oracle from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. For ...
dbExpress is a database-independent layer that defines common interface to provide fast access to PostgreSQL from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms....
You’ll learn how to master the command-line prompt, secure your system, and perform administration tasks like scheduling backups and managing users.A full version of the SUSE operating system is ...
For example, if you want to run the supplied utilities from the command line, you can, if you wish, add the 'bin' subdirectory to the PATH environment variable. If you want to make programmes in C ...
USBlyzer is an easy to use software USB protocol analyzer for Windows, which provides a complete yet simple to understand view for analyzing USB Host Controllers, USB Hubs and USB Devices activity. ...
You will have to manually mount the darwin.iso for example on Workstation and Player. The vmwarebase code does not need to be patched on OS X or ESXi so you will see a message on those systems ...
When no X11 Display is available on a UNIX machine (also called headless environment) or when GDI resources are low on Windows, it is impossible to compute off-screen images with java.awt.Graphics ...
In this chapter, you'll learn additional ways DTrace can profile code, as well as how to augment existing code without laying a finger on the actual executable itself. 27. DTrace vs objc_msgSend In ...
Primarily intended for use by developers working on the native MS-Windows platform, but also available for cross-hosted use, (see note below -- you may need to follow the "read more" link to see it), ...
You will have to manually mount the darwin.iso for example on Workstation 11 and Player 7. The vmwarebase code does not need to be patched on macOS or ESXi so you will see a message on those systems ...
You will have to manually mount the darwin.iso for example on Workstation 11 and Player 7. The vmwarebase code does not need to be patched on OS X or ESXi so you will see a message on those systems ...
《BS ISO 20417:2021 医疗器械 - 制造商需提供的信息》标准是国际标准化组织(ISO)与英国标准协会(BSI)联合制定的一项重要规范,旨在确保医疗器械在设计、制造和使用过程中提供充分、准确的信息,以保障患者安全...
with reviews or scholarly analysis or material supplied specifically for the purpose of being entered and executed on a computer system, for exclusive use by the purchaser of the work. Duplication of ...
to ask for help via email, but I cannot guarantee that I will have time to help you or even reply to your mail. If you absolytely can't live without my help, you can alway try bribing me. You can ...
BS ISO 20417-2021 Medical devices — Information to be supplied by the manufacturer.pdf
We have supplied an extensive bibliography and pointers to the current literature. Each chapter ends with a set of "chapter notes" that give historical details and references. The chapter notes do not...
Exempted from this legal reservation are brief excerpts in connection with reviews or scholarly analysis or material supplied specifically for the purpose of being entered and executed on a computer ...
supplied specifically for the purpose of being entered and executed on a computer system, for exclusive use by the purchaser of the work. Duplication of this publication or parts thereof is permitted ...