On Sunday 28 March 2004 14:25, Josh Berkus wrote:
> Andrew,
>
> > I used to use the connect-by patch, but have since rewritten everything
> > to use a nested set model.
>
> Cool! You're probably the only person I know other than me using nested
> sets in a production environment.
You cut me deep
Andrew,
> Its a way of representing a tree with right-left pointers in each
> record (basically re-inventing a hierarchical database
> in a relational model...). A good description is in Joe Celko's SQL
> For Smarties book. Selection is very fast because
> any node's children have node ID's b
thanx a lot
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, pl
Its a way of representing a tree with right-left pointers in each
record (basically re-inventing a hierarchical database
in a relational model...). A good description is in Joe Celko's SQL
For Smarties book. Selection is very fast because
any node's children have node ID's between the right an
Andrew,
> I used to use the connect-by patch, but have since rewritten everything
> to use a nested set model.
Cool! You're probably the only person I know other than me using nested
sets
in a production environment.
can you explain me what is a nested set?
Well, I don't know if I would use it in an insert-heavy environment (at
least the way I implemented it), but for select-heavy
stuff I don't know why you would want to use anything else. Hard to
beat the performance of a simple BETWEEN.
On Mar 28, 2004, at 2:25 PM, Josh Berkus wrote:
Andrew,
I
Andrew,
> I used to use the connect-by patch, but have since rewritten everything
> to use a nested set model.
Cool! You're probably the only person I know other than me using nested sets
in a production environment.
--
Josh Berkus
Aglio Database Solutions
San Francisco
---
I used to use the connect-by patch, but have since rewritten everything
to use a nested set model. I was
having problems that, while not immediately traceable back to the
patch, showed up when I started
using it and went away when I stopped (strange locking behavior,
crashing with vacuum full, p
Quig,
> Your responses have made it much clear for us. BTW, do you
> think that it's better for us just to rewrite everything so we don't
> need to use the patch at all? Why do others still use it?
Others use it because of the same reason you do.
If you want to use the patch for seemless port
Thanks a lot! We were migrating to Postgres from Oracle and
every now and then, we ran into something that we do not
understand completely and it is a learning process for us.
Your responses have made it much clear for us. BTW, do you
think that it's better for us just to rewrite everything so we
Andrew Overholt did some preliminary work toward implementing the
SQL99-spec WITH functionality (which subsumes what CONNECT BY does,
and a few other things too). But he's left Red Hat and gone back
to school. One of the many things on my todo list is to pick up that
patch and get it finished.
Ou
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Is there still someone around who's working on getting a similar patch
> into 7.5? Seems there huge user demand for such a thing...
Andrew Overholt did some preliminary work toward implementing the
SQL99-spec WITH functionality (which subsume
Theory B, of course, is that this is an actual bug in the patch and not
just incorrect installation. I'm not interested enough to investigate
though.
Is there still someone around who's working on getting a similar patch
into 7.5? Seems there huge user demand for such a thing...
(And no, I'm
Josh Berkus <[EMAIL PROTECTED]> writes:
>> Oh, good eye ... it's that infamous CONNECT BY patch again, without doubt.
> Hey, who does this patch? What's wrong wiith it?
I'm just venting my annoyance at people expecting us to support
hacked-up versions, especially without telling us they're hack
Tom,
> Oh, good eye ... it's that infamous CONNECT BY patch again, without doubt.
Hey, who does this patch? What's wrong wiith it?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 6: Have you searched our l
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Thu, 25 Mar 2004, Qing Zhao wrote:
>> start with customer_part_number = 'Top Assembly 1'
>> connect by parent_part_number = prior customer_part_number;
> What version are you running, and did you apply any patches (for example
> one to support the sta
It is 7.3.4 on MAC OS X (darwin). The patch we applied is hier-Pg7.3-0.5, which allows
to perform hierarchical queries on PgSQL using Oracle's syntax.
Thanks!
Qing
On Mar 25, 2004, at 2:57 PM, Stephan Szabo wrote:
On Thu, 25 Mar 2004, Qing Zhao wrote:
select
_level_ as l,
nextval('seq_pk_bom_
On Thu, 25 Mar 2004, Qing Zhao wrote:
>select
>_level_ as l,
> nextval('seq_pk_bom_detail') as bom_detail,
> prior nextval('seq_pk_bom_detail') as parent_subassembly,
>parent_part_number,
> customer_part_number,
>/* mfr_name,
> mfr_part,
> description,*/
> c
Tom,
Thanks for your help!
It's not through one client. I am using JDBC. But the same things
happen when I use client like psql.
Qing
On Mar 25, 2004, at 10:20 AM, Tom Lane wrote:
Qing Zhao <[EMAIL PROTECTED]> writes:
I have a query which get's data from a single table.
When I try to get data
Qing Zhao <[EMAIL PROTECTED]> writes:
> It's not through one client. I am using JDBC. But the same things
> happen when I use client like psql.
That's really hard to believe. Can you provide a reproducible test
case?
regards, tom lane
---(end of
Qing Zhao <[EMAIL PROTECTED]> writes:
> I have a query which get's data from a single table.
> When I try to get data from for an RFQ which has around 5000 rows, it
> is breaking off at 18th row.
> If i reduce some columns , then it returns all the rows and not so slow.
What client-side softwar
I have a query which get's data from a single table.
When I try to get data from for an RFQ which has around 5000 rows, it is breaking off at 18th row.
If i reduce some columns , then it returns all the rows and not so slow.
I have tried with different sets of column and there is no pattern base
22 matches
Mail list logo