Re: Recursive Arrays 101
| От | Achilleas Mantzios |
|---|---|
| Тема | Re: Recursive Arrays 101 |
| Дата | |
| Msg-id | 5639D80D.7010204@matrix.gatewaynet.com обсуждение исходный текст |
| Ответ на | Re: Recursive Arrays 101 ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: Recursive Arrays 101
|
| Список | pgsql-general |
Sorry for being kind of late to the party (I was in 2015.PgConf.EU !!), and not having read
most of the replies, what we have been successfully doing for this problem for our app
is do it this way :
parents int[] -- where parents stores the path from the node to the root of the tree
and then have those indexes :
btree (first(parents))
btree (level(parents)) -- length
btree (last(parents))
gin (parents gin__int_ops) -- the most important
This has been described as "genealogical tree" approach, and works very good, IMHO much better
than nested sets.
On 27/10/2015 14:46, David G. Johnston wrote:
most of the replies, what we have been successfully doing for this problem for our app
is do it this way :
parents int[] -- where parents stores the path from the node to the root of the tree
and then have those indexes :
btree (first(parents))
btree (level(parents)) -- length
btree (last(parents))
gin (parents gin__int_ops) -- the most important
This has been described as "genealogical tree" approach, and works very good, IMHO much better
than nested sets.
On 27/10/2015 14:46, David G. Johnston wrote:
On Monday, October 26, 2015, John R Pierce <pierce@hogranch.com> wrote:On 10/26/2015 7:44 PM, David G. Johnston wrote:They both have their places. It is usually quite difficult to automate and version control the manual work that goes into using command line tools.
I hope you mean, its difficult to automate and version control clickity-clicky work that goes into using GUI tools
automating shell scripts is trivial. putting said shell scripts into version control is also trivial.Yes, that is a typo on my part.
-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt
В списке pgsql-general по дате отправления: