[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bricolage-devel
Subject:    Re: [Bricolage-Devel] database upgrade
From:       David Wheeler <david () kineticode ! com>
Date:       2004-03-18 16:12:31
Message-ID: 0F124F1E-78F7-11D8-921D-000A95972D84 () kineticode ! com
[Download RAW message or body]

On Mar 17, 2004, at 11:19 PM, Dave Rolsky wrote:

> Right, so "ON LCASE(user(login)) WHERE active = 1"
>
> My point was why not stick LCASE into the index?

I did. Here is what I created:

   CREATE UNIQUE INDEX udx_usr__login ON usr(LOWER(login)) WHERE active 
= 1;

Regards,

David



-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
Bricolage-Devel mailing list
Bricolage-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-devel
[prev in list] [next in list] [prev in thread] [next in thread]