Horton

Re: Index on a function(field)

Mitch Vincent <mitch@venux.net>

View thread View on postgr.es
From: "Mitch Vincent" <mitch@venux.net>
To: "Gabriel Fernandez" <gabi@unica.edu>, "PostgreSQL-general" <pgsql-general@postgreSQL.org>
Date: 2001-05-11T18:23:38Z
Lists: pgsql-general 
> Is it possible to create an index using a function(field) sintaxis ?

As far as I know you can -- I have lots of indexes on lower(varchar).. There
may be limitations though so I'll let someone else have the final word :-)

-Mitch