Because the error message saying so (I do use pgAdmin III): "An error has occurred: ERROR: the datatype character varying has no standard operator class for "gist" access method HINT: You should specify na operator class for the index or define one standard operator class for the data type." (I've translated the above message from portuguese to english, sorry if it's not exact). That's why I can't use GIST. Thanks, Edson. -----Mensagem original----- De: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] Em nome de Alban Hertroys Enviada em: segunda-feira, 26 de setembro de 2011 12:37 Para: Edson Carlos Ericksson Richter Cc: pgsql-general@xxxxxxxxxxxxxx Assunto: Re: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries? On 26 September 2011 17:15, Edson Carlos Ericksson Richter <richter@xxxxxxxxxxxxxx> wrote: > Just discovered, I can't use GIST over character varying... Why do you think that? -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
<<attachment: smime.p7s>>
