Re: Indexes

On Wed, Aug 29, 2001 at 10:44:56AM +0200, Stan wrote:
> How can I change the sequence of characters in PostgreSQL character indexes

create index some_ix
on some_tbl ( substr(some_fld,3,1) || substr(some_other_fld,12,5) );

but if you look hard enough, you'll usually find a better model
by restructuring your data.

--
Hey, let's change the whole justice system. Everybody gets to
kill one person -- if you do two, you go to jail. That should
cut down on the abrasive personalities, don't you think?

will(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!