This depends on exactly what you need. In the end usually you are going to
want to convert things into integer arrays.
In LedgerSMB we use integers and foreign keys to handle hierarchies, and
then convert them to int arrays via WITH RECURSIVE CTE's and text strings .
This is one of those things
On Tue, Aug 6, 2013 at 2:36 PM, Derek Poon wrote:
> The performance impact of the enhanced comparator would probably be
> negligible, compared to I/O bottlenecks. A bigger issue would be backwards
> compatibility, especially for ltrees with existing btree indexes.
>
> Feedback? Suggestions?
U
Hi,
I'm looking for a data type to store numerically labelled hierarchical data,
such as section.subsection.paragraph numbers (e.g. '1.5.3', '1.10.2', '6.30').
The closest data type that I have found is ltree. However, the collation order
is inappropriate: it would put '1.10.2' before '1.5.3',
