Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #424
| From | Jasen Betts <jasen@xnet.co.nz> |
|---|---|
| Newsgroups | comp.databases.postgresql |
| Subject | Re: Best way to do recursive query for tree like records ? |
| Date | 2012-11-23 09:50 +0000 |
| Organization | Dis (not Dat) Organisation |
| Message-ID | <k8ngtu$3oa$1@reversiblemaps.ath.cx> (permalink) |
| References | <8d44d8a0-8c8b-4a40-bb70-15f6a430d8ee@googlegroups.com> |
On 2012-11-23, Ziliang Chen <zlchen.ken@gmail.com> wrote: > Hi Guys, > > I have billions of tree like records in PostgreSQL 9.2 database on > RHEL 5 X64, what is the best way to do the query in PostgreSQL, like : > "find out all records (grand records ...) under one (several) specific > parent node(s) ? or find out all parent nodes (grandparent nodes...) > for one (several) specific child node(s) ?" Not clear. parentheses mean what? -- ⚂⚃ 100% natural --- news://freenews.netfront.net/ - complaints: news@netfront.net ---
Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Best way to do recursive query for tree like records ? Ziliang Chen <zlchen.ken@gmail.com> - 2012-11-22 20:32 -0800
Re: Best way to do recursive query for tree like records ? Jasen Betts <jasen@xnet.co.nz> - 2012-11-23 09:50 +0000
Re: Best way to do recursive query for tree like records ? "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-11-23 11:05 +0100
Re: Best way to do recursive query for tree like records ? Ziliang Chen <zlchen.ken@gmail.com> - 2012-11-23 05:47 -0800
csiph-web