Baron Schwartz wrote:
On Tue, Aug 12, 2008 at 8:07 PM, Brian Aker <[EMAIL PROTECTED]> wrote:
OK I give up. But there's something useful in here, I just can't
articulate it.
What I think you are looking for is something that is a trigger, but not
quite a trigger.
I am looking for the same thing myself frequently... I do not see us
implementing triggers anytime soon, but I see a need for some sort of
callback on execution. I would not call it a trigger though since it would
not quite be that...
Right -- the ability to evaluate an expression (no procedural code)
and assign the result to the column. A very special-case trigger.
Why not function based indexes, as Baron pointed to as the last option
in his previous reply?
I've wanted function based indexes since the dawn of time in MySQL -
well, at least since Oracle 8i anyway.. ;)
http://www.akadia.com/services/ora_function_based_index_2.html
In MySQL Worklog parlance, they are 'Functional Indexes', or 'Calculated
Indexes', a public worklog for this is here:
http://forge.mysql.com/worklog/task.php?id=1075
This looks like exactly what you guys are talking about, and does not
give the need to store the value in another separate column, with
another index etc. (... more space)..
--
Mark Leith
MySQL Regional Support Manager, Americas
Sun Microsystems, Inc., http://www.sun.com/mysql/
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
