Rails - Dec 2005 - Lack of 'LEFT JOIN' in Oracle 8, any patch for theta style (+)

Dears,

Oracle 8 don''t support ANSI  syntax with :

SELECT e.emp_id,
          e.fname,
          e.lname,
          j.jobdesc
FROM employe e
LEFT JOIN jobs j ON e.job_id = j.job_id

but only

SELECT e.emp_id,
          e.fname,
          e.lname,
          j.jobdesc
FROM employe e,
           jobs      j
WHERE j.job_id (+) = e.job_id

JOIN syntax came with 9i.

Anyone patched Rails source for supporting that (+) ''theta''
style ?

I''m using 8.1.7 and LEFT JOIN is builded into class
HasAndBelongsToManyAssociation to provide HABTM

Thanks!

--
Mathieu

On 5-dec-2005, at 17:24, Mathieu Chappuis wrote:
>
> JOIN syntax came with 9i.
>
> Anyone patched Rails source for supporting that (+)
''theta'' style ?
>
> I''m using 8.1.7 and LEFT JOIN is builded into class
> HasAndBelongsToManyAssociation to provide HABTM


This OT but funny because sqlite3 does not support RIGHT JOIN. So we  
actually have NO DB-agnostic joins :-)


--
Julian ''Julik'' Tarkhanov
me at julik.nl