Re: Using pg_trgm

JORGE MALDONADO <jorgemal1960(at)gmail(dot)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(at)spamfence(dot)net
> > wrote:
>
> JORGE MALDONADO <jorgemal1960(at)gmail(dot)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(at)postgresql(dot)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°