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?
 
[EMAIL PROTECTED]
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to