PostgreSQL ltree- vs tree module vs integer/string arrays or string delimited path PostgreSQL ltree- vs tree module vs integer/string arrays or string delimited path postgresql postgresql

PostgreSQL ltree- vs tree module vs integer/string arrays or string delimited path


AS far as I read, contrib/tree was never officially released, whereas ltree was merged into PostgreSQL's core.

I understand both use the same idea of labeled path, but tree only allowed integer labels, when ltree allows text labels that permits fulltext searches, thought the full path length is limited (65Kb max, 2Kb prefered).