Re: Same table multiple times

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Jan 29 2004 - 11:24:57 EST

Next message: Andrus Adamchik: "Re: New objects break FK constraints"

Previous message: Jim Menard: "New objects break FK constraints"
In reply to: Jim Menard: "Same table multiple times"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi Jim,

At the moment we do not support such expressions. This was discussed in
a lengthy thread in September-October:
http://objectstyle.org/cayenne/lists/cayenne-devel/2003/09/0096.html
(see description of "dontSplitUpTo"), but hasn't been implemented due
to the busy schedule of the volunteers.

Andrus

On Jan 28, 2004, at 7:48 PM, Jim Menard wrote:
>
> SELECT ...
> FROM photo t0, metadata t1, metadata t2
> WHERE t0.id = t1.photo_id
> AND t0.id = t2.photo_id
> AND (t1.value LIKE '%Fred%' AND t1.type = 1)
> AND (t2.value LIKE '%Paris%' AND t2.type = 4)

Next message: Andrus Adamchik: "Re: New objects break FK constraints"
Previous message: Jim Menard: "New objects break FK constraints"
In reply to: Jim Menard: "Same table multiple times"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Thu Jan 29 2004 - 11:25:02 EST