Thread: using the difference function

Hi,

I am new to PostgreSQL but have a strong background is MS SQL Server.

I am trying to use the difference function within embedded sql using Npsql.

I receive the following error:

Error: 42883: function difference(text, text) does not exist.

A bit of googling shows me that the difference function is part of a fuzzystrmatch module.
I have installed PostgreSQL 8.3 using a windows exe. Looking under C:\Program Files\PostgreSQL\8.3\lib i can see fuzzystrmatch.dll.

However it is not in the bin folder.
Is this function considered a bolt-on to PostgreSQL and if so:
1.  How do I install it?
2. Does it install to the server or to each database?
Best regards
Phil Smith

This email (including any attachments) may contain confidential
and/or privileged information or information otherwise protected
from disclosure. If you are not the intended recipient, please
notify the sender immediately, do not copy this message or any
attachments and do not use it for any purpose or disclose its
content to any person, but delete this message and any attachments
from your system. Astrium disclaims any and all liability if this
email transmission was virus corrupted, altered or falsified.
-o-
Astrium Limited, Registered in England and Wales No. 2449259
Registered Office:
Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England

On Thu, Jun 25, 2009 at 06:07:22PM +0100, SMITH, Phillip (external) wrote:
>    I have installed PostgreSQL 8.3 using a windows exe. Looking under
>    C:\Program Files\PostgreSQL\8.3\lib i can see fuzzystrmatch.dll.
>
>    However it is not in the bin folder.
>    Is this function considered a bolt-on to PostgreSQL and if so:
>    1.  How do I install it?

I don't do windows, so can't tell you exactly, but there should be a
fuzzystrmatch.sql file somewhere there as well. Run that SQL script, i.e.
     psql -f fuzzystrmatch.sql database_name

>    2. Does it install to the server or to each database?

You'll need to run that install script in each database where you'd like to
have fuzzystrmatch functions available. Alternatively, run it in the template1
database before creating the databases you want it used in, and it will be
automatically installed in each database.

- Josh / eggyknap