| From: | Don Parris <parrisdc(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Using Ltree For Hierarchical Structures |
| Date: | 2013-02-24 22:20:32 |
| Message-ID: | CAJ-7yonEdms9gwr8mzfXQUFQAoUScykPec=6n9K2s93JMWPj7A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi all,
With many thanks to Misa and others who helped out with my question about
working with hierarchical data, I have now written a blog post on how I
implemented the ltree module to solve my problem.
http://dcparris.net/2013/02/24/using-ltree-hierarchical-postgresql/
Frankly, if you work with hierarchical data, I'm not sure I could recommend
it strongly enough. I should think that even experienced, advanced SQL
gurus would appreciate the simplicity ltree offers, when compared to the
ugly table designs and recursive queries in order to work with hierarchical
structures.
I really hope this blog post will help others in the same boat.
Regards,
Don
--
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/
<https://www.xing.com/profile/Don_Parris><http://www.linkedin.com/in/dcparris>
GPG Key ID: F5E179BE
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Surfing | 2013-02-25 18:34:10 | Euclidean distance between two sets of tuples |
| Previous Message | Don Parris | 2013-02-23 21:30:50 | Re: Summing & Grouping in a Hierarchical Structure |