Re: Using pg_trgm

JORGE MALDONADO <jorgemal1960@gmail.com> wrote:

> Thanks for your reply.
> I am issuing the "create extension" command but I get an error message saying
> that there is a syntax error in or near the word "extension".
> What can be happening?

Which version you are using?




>
> Regards,
> Jorge Maldonado
>
> On Tue, Mar 13, 2012 at 10:51 AM, Andreas Kretschmer <akretschmer@spamfence.net
> > wrote:
>
>     JORGE MALDONADO <jorgemal1960@gmail.com> wrote:
>
>     > I tried to use the "similarity" function to detect possible duplicated in
>     a
>     > table but it is not recognized. Is there something I have to do before
>     using
>     > it? What is the correct procedure to get it working?
>
>     Create extension?
>
>     test=# create extension pg_trgm;
>     CREATE EXTENSION
>     Time: 176,301 ms
>
>
>
>     Andreas
>     --
>     Really, I'm not out to destroy Microsoft. That will just be a completely
>     unintentional side effect.                              (Linus Torvalds)
>     "If I was god, I would recompile penguin with --enable-fly."   (unknown)
>     Kaufbach, Saxony, Germany, Europe.              N 51.05082 , E 13.56889
>
>     --
>     Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-novice
>
>


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°