EOF & pgSQL join syntax
EOF & pgSQL join syntax
- Subject: EOF & pgSQL join syntax
- From: Arturo Pérez <email@hidden>
- Date: Thu, 29 Apr 2004 10:13:41 -0400
Hi all,
I have a relationship that requires an outer join. Left/right I'm not
sure yet. That's beyond my sqlness :-)
The problem I'm having is that the syntax generated by EOF is
"SELECT <blah,blah> FROM x t0, y T3, z T2, w T1 WHERE T3.P1 = ? AND
T2.S = T3.S AND t0.P = T2.P AND t0.R *=* T1.R" withBindings:
1:"joey"(p1)>:
That *=* does not compute with PostgreSQL. Left outer generates *= and
right outer generates =*. How do I get EOF to generate SQL92 compliant
join syntax; i.e. LEFT OUTER JOIN table1?
I'm using the hexdreams plug-ins 1.2 Panther 10.3.2 xCode 1.1, pgSQL
7.4.1, pgSQL jdbc pg74.1jdbc3.jar and WO/EOF 5.2.
TIA,
arturo
----
WO in philadelphia - wanna cheesesteak with that?
Please visit webobjects.meetup.com.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.