hierarchy-data-closure-table icon indicating copy to clipboard operation
hierarchy-data-closure-table copied to clipboard

This is a mysql and postgresql store procedure and trigger implementation of closure table in RDBMS about hierarchy data model.

Results 8 hierarchy-data-closure-table issues
Sort by recently updated
recently updated
newest added

您好,我是从segmentfault论坛里过来的,想请问一下,《Collectd & InfluxDb & Grafana 之一: 常用系统统计》这篇文章里,您的数据包是通过什么统计的呢?

This is the best closure repo so far! However, I am unable to get the hide node procedure working: Steps to reproduce: 1. run the mysql.sql provided in this repo...

~My bad.~ Run `mysql/all-in-one.sql` and then try moving C0 under B0 or any A node. Instead of having 1,3,2 as breadcrumbs, it will have 1,2,3.

Lack of `null` safe comparison lead to procedure not being called when changing node's parent to `null`

postgresql part is NOT WORKABLE! in all sql can't be fully exec and no trigger test date is bad. notice should be listed in read me.

if I execute the following sqll code: CREATE TABLE public.prefix_nodes (    id integer NOT NULL DEFAULT nextval ('prefix_nodes_id_seq' :: regclass), I return as an error the "prefix_nodes_id_seq" relationship does not...

What is the license being used in this repository? There appears to be an empty license file. Thanks!

Hi I am trying to follow the steps and delete a node > Hide or show nodes from subtree, explains as following: > > Step 1. call p_get_tree(6) get the...