Home > mailing lists

Re: Hierarchical numeric data type - Mailing list pgsql-general

From	Chris Travers
Subject	Re: Hierarchical numeric data type
Date	August 7, 2013 13:21:08
Msg-id	CAKt_ZfundccbWMWwXssD8VnVy_DsboJMdVkWxFmzR8CWdYjq6g@mail.gmail.com Whole thread Raw
In response to	Re: Hierarchical numeric data type (Sergey Konoplev <gray.ru@gmail.com>)
List	pgsql-general

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 where hierarchical data design can depend heavily on the use case.

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

From: Vishalakshi Navaneethakrishnan
Date: 07 August 2013, 12:47:32
Subject: How to avoid Force Autovacuum

From: Sameer Thakur
Date: 07 August 2013, 13:34:07
Subject: Populating array of composite datatype