[Rt-devel] create index on groups(instance) is a booster

[Andrew Sullivan]

On Fri, May 14, 2004 at 10:05:16AM -0400, Vivek Khera wrote:
> if it was created with lower().  I'm not sure how to create 
> multi-column functional indexes, however.  

This seems to work:

CREATE INDEX t1_t2_lower_idx on foo (lower(t1),lower(t2));

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what 
you told them to.  That actually seems sort of quaint now.
		--J.D. Baldwin