Hi, I'm using the pg_trgm module, Is there a possibility not to convert one side of the string when comparing? I need a kind of reference string containing only certain trigrams. It's not possible to build every kind of string using the function. example: Code: Alles auswählen SELECT show_trgm('abc'); show_trgm ------------------------- {" a"," ab",abc,"bc "} (1 row) But I like to have only {'abc'} for example. I would use this function: "similarity(text, text)" Could it somehow work with explicit data-type definitions or maybe with putting the string in brackets or quoting? Or do I have to change the source code? Thanks for your help Janek Sendrowski -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general