Re: Index on a function(field)

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: "Gabriel Fernandez" <gabi(at)unica(dot)edu>, "PostgreSQL-general" <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: Index on a function(field)
Date: 2001-05-11 18:23:38
Message-ID: 010701c0da47$7fce17c0$1251000a@windows
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ed Loehr 2001-05-11 18:42:59 7.0.0 long name truncation problem
Previous Message kapil c. tilwani 2001-05-11 18:14:19