Home
The Toolkit for Online Communities
15903 Community Members, 0 members online, 2311 visitors today
Log In Register

Forum OpenACS Q&A: Response to Problem with connect by

OpenACS Home : Forums : OpenACS Q&A : Response to Problem with connect by : One Message

+
Posted by Claudio Pasolini on
Well, I found a viable solution:
  • I recreated the tree_encodings table with the same collating sequence used by Postgres (select code from tree_encodings order by code)
  • I modified the next_sortkey function using the first character in the collating sequence instead of '0' to denote the first key of any level
  • Now things run smoothly.

    Claudio Pasolini