Re: About Itzik's "Maintaining Hierarchies"

Centuries ago, Nostradamus foresaw when "Jonah Olsson" <jonah_at_IHATESPAM.com> would write:
> Many of my customers indicates that they want to switch to MySQL etc. in a
> near future. And since MySQL (among others) doesn't support Triggers, the
> idea of having triggers to maintain hierarchical data becomes a problem.
>
> The article on "Maintaining Hierarchies" by Itzik
> (http://www.winnetmag.com/SQLServer/Articles/ArticleID/8826/pg/1/1.html) is
> such a problem. The article itself is excellent, but how can I keep the same
> integrity without using triggers, in perhaps MySQL?

"Maintaining integrity" and "MySQL(tm)" don't generally seem to fit in the same sentence very well. <http://sql-info.de/mysql/gotchas.html>

Perhaps you should suggest that:

1. Your customers wait until the product includes such necessary features, or that
2. Your customers look at other alternatives that _do_ provide the necessary features.

If they aren't willing to listen to you, then you've got to wonder if they're the kind of customers you want...

-- 
output = reverse("ofni.secnanifxunil" "_at_" "enworbbc")
http://www.ntlug.org/~cbbrowne/spreadsheets.html
Would-be National Mottos:
Tibet: "It's all downhill from here!"