Hi Don,
thanks for the in-depth reply.
<blockquote> would have the same problems it had when we first
tried it in Postgres
</blockquote>
Could you explain these problem, please? We've added tree_sortkey to our "im_menu" object so far at Project/Open using VARCHAR and didn't encounter any problems yet. However, there are very few menu objects (some 30), so we are actually using a TCL procedure to calculate the sortkeys. Very slow and ugly, but it works for both Oracle and Postgres...
Bests,
Frank
http://www.project-open.com/