Beermann, Albert wrote: > > Hello Everbody ! > > I want to create an index on upper(name1) > > create index stadressstammname1 on stadressstamm (upper(NAME1))
You missed the fact, that indexes are allowed only on database functions, meaning user defined functions, not pre-defined functions described in the manual. So you have to create a database function, use there the pre-defined function upper in and then use the user-defined-function name in the create index statement http://dev.mysql.com/doc/maxdb/en/5a/962f81d1cbbb408c11829eb08051f3/fram eset.htm Elke SAP Labs Berlin > > Error: unknown database function upper > > Any help welcomed. > Best regards > Albert > ''''' > ''''''''' > (0 0) > +---------oOO-----------(_)------------------------------+ > | Tel: 0541/5841-868 | > | Fax: 0541/5841-869 | > | Mail: mailto:[EMAIL PROTECTED] | > | Internet: http://www.piepenbrock.de | > +--------------------------------------oOO----------------+ > |__|__| > || || > ooO Ooo > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
