re: "connect by" clause...

2002-12-25 Thread Victoria Reznichenko
On Tuesday 24 December 2002 16:52, Gabriele Carioli wrote: > It's Christmas and I'm sending my wish list to Santa Claus... > ;o) > > 1. hierarchical queries [skip] > it is possible to execute a query like: > > SELECT * FROM data CONNECT BY id PRIOR pnt START WITH id=0; [skip] It's in the TODO

"connect by" clause...

2002-12-24 Thread Gabriele Carioli
Hi. It's Christmas and I'm sending my wish list to Santa Claus... ;o) 1. hierarchical queries I've seen an interesting patch to PostgreSQL to implement hierarchical queries similar to those available with Oracle (http://gppl.terminal.ru/readme.html). This kind of query makes handling trees a