I would use a view for that (in an ideal world, a materialized view). Views also can have cascading updates, in the case where the SQL for the field you want isn't just a SELECT....
But I cheated, because a few weeks ago I wrote a chapter about views, so I'm pretty intimate with them right now. :) -Sheeri (who is now reminded why she wanted the VIEWs and TRIGGERs to go into the same chapter). On 8/12/08, Baron Schwartz <[EMAIL PROTECTED]> wrote: > > On Tue, Aug 12, 2008 at 8:07 PM, Brian Aker <[EMAIL PROTECTED]> wrote: > > Hi! > > > > On Aug 12, 2008, at 4:58 PM, Baron Schwartz 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. > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- - Sheeri K. Cabral Note: Currently I work for The Pythian Group (http://www.pythian.com/ ), a remote DBA firm, and consulting would constitute a conflict of interest. However, I do recommend our work, and if you're looking for DBA work (I do MySQL work, but they have great Oracle and SQL Server DBAs too) right now, whether you need a few hours a week, or someone fulltime while you continue a job search. I have a webpage with tips on how to find a DBA: http://sheeri.net/how-to-find-a-dba/ I can recommend http://www.toomanyconnections.com as a good site to find MySQL (and Oracle) DBAs. If you're looking for web design, I recommend the small business my husband works for, http://www.digital-loom.com I regret that I have no other information for any other type of position, including developer, programmer and systems administrator.
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
