Self-join

• Previous message: Andrus Adamchik: "Re: How to set setEndToEndMetrics through Cayenne"
• In reply to: Andrus Adamchik: "Re: SQLTemplate not faulting an object"
• Next in thread: Mike Kienenberger: "Re: Self-join"
• Reply: Mike Kienenberger: "Re: Self-join"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

What is the status of self joins in v. 1.2.3?
From the 2 posts I find in the archive seems like some people are using
it.
The documentation doesn't mention it.
Just wondering if it's ok to use or if there are any limitations that
discourages it's use?

I'm have a set of nodes. I'm guessing the source node will have
Source_node_id NULL or 0. And then the target nodes will refer back to
the source nodes Node_id. Would it be worth using self joins here or
should I just look up the target nodes based on the source nodes using
regular queries and not worry about the relations?

NODE

Node_id (pk)
Text
Source_node_id (fk)

Thanks!
Fredrik

• Next message: Mike Kienenberger: "Re: Self-join"
• Previous message: Andrus Adamchik: "Re: How to set setEndToEndMetrics through Cayenne"
• In reply to: Andrus Adamchik: "Re: SQLTemplate not faulting an object"
• Next in thread: Mike Kienenberger: "Re: Self-join"
• Reply: Mike Kienenberger: "Re: Self-join"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Tue Jun 12 2007 - 15:19:17 EDT