cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fredrik Liden" <fli...@translate.com>
Subject Self-join
Date Tue, 12 Jun 2007 19:18:50 GMT
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

Mime
View raw message