Thread: Using pg_trgm
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?
Respectfully,
Jorge Maldonado
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°
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°
JORGE MALDONADO <jorgemal1960@gmail.com> wrote: > PostgreSQL 9.0 > > Regards, > Jorge Maldonado 1st: don't top-quoting 2nd: answer to the list, not to me 3rd: Extensions are new since 9.1, so you have to run the install-script, please read http://www.postgresql.org/docs/9.0/static/contrib.html how to install contrib-modules. Regards, 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°