Forum OpenACS Q&A: ACSpg3.2 SQL changes: u.user_id(+) to what?
Posted by Tom Jackson on 04/11/00 02:37 AM
A number of sql statements are upsetting PostgreSQL 7. Many of them
have a common element:
(+) at the end of a field name.
Here is one full statement along with the error code.
Is this the problem? Any way I can help? Is there a better place for me to discuss this?
Posted by Lamar Owen on 04/11/00 02:47 AM
Looks like you have an outer join. Outer Joins are not yet supported in PG 7. See the porting guidlines for more information.
Posted by Ben Adida on 04/11/00 02:48 AM
What you're seeing here is an outer join. The idea is relatively involved, so I recommend reading up on Philip's SQL guide at photo.net/sql. We're porting a bunch of these already (check out the porting guide in the manual page), however this one isn't ported because of the "connect by" which we haven't been able to solve yet... Another Oracle construct.