using the difference function
| От | SMITH, Phillip \(external\) |
|---|---|
| Тема | using the difference function |
| Дата | |
| Msg-id | 7421086474A3DB4989F94A88D2F7F198010EB943@VSMAIL1.uk.astrium.corp обсуждение исходный текст |
| Ответы |
Re: using the difference function
|
| Список | 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 |
В списке pgsql-novice по дате отправления: