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: [email protected] [mailto:[email protected]] Em nome de Alban Hertroys Enviada em: segunda-feira, 26 de setembro de 2011 12:37 Para: Edson Carlos Ericksson Richter Cc: [email protected] Assunto: Re: [GENERAL] Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries? On 26 September 2011 17:15, Edson Carlos Ericksson Richter <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
smime.p7s
Description: S/MIME cryptographic signature
