using the difference function

From: "SMITH, Phillip \(external\)" <phillip(dot)smith(at)astrium(dot)eads(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: using the difference function
Date: 2009-06-25 17:07:22
Message-ID: 7421086474A3DB4989F94A88D2F7F198010EB943@VSMAIL1.uk.astrium.corp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Joshua Tolley 2009-06-25 20:48:57 Re: using the difference function
Previous Message Tim Ryan 2009-06-25 13:53:03 Re: Problems importing csv files