anybody has simple example of acheiving 'powerful' heirarchy table?
i tried with success a method, where in a column stores the whole heirarchy in every record
id userid parent id level heirarchy
1 nick kelvin 5 .22.214.171.124.17.
the problem is, if the heirarchy is VERY Large, it goes beyond the heirarchy columns limit of 8000 characters, and i have to change it to datatype of text, in which i cannot use triggers anymore, to update the column
would greatly appreciate if anyone can recommend an easier/smarter way to implement this
easy in sense of inserting. updating/deletion not neccessary