outer joins

From: Aristedes Maniatis (ar..aniatis.org)
Date: Wed Jan 13 2010 - 04:44:22 EST

  • Next message: Andrus Adamchik: "Re: outer joins"

    On 13/01/10 6:53 PM, Andrus Adamchik wrote:
    > http://cayenne.apache.org/doc/path-expressions.html ("Aliases in Path
    > Expressions")

    Just to be clear, does Cayenne always produce a LEFT OUTER JOIN when using the "+" notation?

    The example at the top of the page with "toArtist.exhibitArray+.closingDate" when used in a query will effectively mean: "find all paintings by an artist who has an exhibition closing on date x, and also find all paintings by artists with no exhibitions". Does that sound right?

    Also, I'm not sure of the point being made in the last section "Matching Path Expressions". Should it be replaced by pointers to:

    * [how to combine expressions | expression factory utilities ]
    * how to use expressions in a query

    Ari 

    -- 
-------------------------->
Aristedes Maniatis
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A

    This archive was generated by hypermail 2.0.0 : Wed Jan 13 2010 - 04:45:01 EST