Dave Merrill wrote: > Frankly, I agree with Matt that search behavior really should be case > insensitive.
Are we talking about searching or equality matching? Because frankly, I don't think there are any 2 databases that have compatible search systems. > If, like most other dbs, searching for calculated expressions > (LCASE(some_column) = 'foo' etc) is significantly inefficient It isn't if you create the right index: CREATE INDEX foo ON bar (LOWER(some_column)); > Are folks really sure that no case-insensitive collation option is available? I don't think so. PostgreSQL uses the collation facilities provided by the host OS so maybe there is one on some OS but I never looked for one. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266560 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
