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
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 |