Postgres Pro
Downloads
Home   >   mailing lists

Re: Index on a function(field) - Mailing list pgsql-general

From Mitch Vincent
Subject Re: Index on a function(field)
Date
Msg-id 010701c0da47$7fce17c0$1251000a@windows
Whole thread Raw
In response to Index on a function(field)  (Gabriel Fernandez <gabi@unica.edu>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: name truncation problem in 7.0.0
Next
From: "Gregory Wood"
Date:
Subject: Re: ALTER TABLE ADD CONSTRAINT