Re: [Flamerobin-devel] Expression indexes

[Fikret H. <fha...@ya...>]

--- Milan Babuskov <mi...@in...>
wrote:

> Nando Dessena wrote:
> > M> What do you mean by "expression indexes"
> anyway?
> > 
> > Computed indexes.
> > 
> > CREATE INDEX UPPER_NAME_INDEX ON EMPLOYEE COMPUTED
> BY (UPPER(NAME));
> 
> Wow. Looks like I missed this absolutely cool
> feature. In some databases 
> I have "extraneous" fields just to be able to
> aggregate on some computed 
> stuff.

It looks like that you missed VERY useful feature ;-)
You should read release notes from time to time ;)


> 
> > I think it's new in Fb 2. The above creates an
> index with no segments
> > and the string "UPPER(NAME)" in
> RDB$EXPRESSION_SOURCE.
> > 
> > What I could do is display the expression source
> instead of the
> > segment list in FR's property page. For long
> expressions this might
> > look ugly on screen, but I don't think anyone is
> using very long index
> > expressions anyway.
> 
> Ok.
> 
> </M>
> 
> 
> 
>
-------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support
> web services, security?
> Get stuff done quickly with pre-integrated
> technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1
> based on Apache Geronimo
>
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Flamerobin-devel mailing list
> Fla...@li...
>
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
> 


-- 
Best regards,
Fikret Hasovic http://fikret.fbtalk.net 
USAID TAMP Senior Programmer
* Firebird Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
* JEDI VCS contributor
http://jedivcs.sourceforge.net/
* Firebird and Fyracle news
http://www.fyracle.org/shownews.php


 
____________________________________________________________________________________
Now that's room service!  Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097