> Isnt the following query supported in postgresql (it is surely useful and
> > supported in MySQL )
> > CREATE INDEX t_index ON (NAME(20) , ID);
> I can't see any particular value in that myself, but Postgres supports
> a generic approach to weird indexing requirements: functional indexes.
Well, i think that partial indexing (on a column) can save a disk
space as well as, a lot of time.In my opinion the query above
is much better than the one below (in terms of time) :
> > CREATE INDEX t_index ON (NAME(200) , ID);
--
------
Varun