Brown, Charles wrote:
Hello Dan. Try it and see if you can:
mysql> create index indx101 on tab101(min(c1),c2) ;
Answer: Its not supported.
-----Original Message-----
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 13, 2007 9:10 AM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: Re: function based index
In the last episode (Mar 13), Ananda Kumar said:
Is it possible to create function based index in mysql as available
in oracle. Please point me to any documentation on this.
Sorry; mysql doesn't have function-based indexes. The closest you can
get in mysql is if you add another column and an UPDATE trigger that
populates it with the results of your function, then index that column.
Hi! We've recently opened up our public worklog for commenting... which
means you should definitely add comments to the worklog task which
covers function indexes:
http://forge.mysql.com/worklog/task.php?id=1075
Cheers!
jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
