Forum OpenACS Development: Re: Eliminating 90% of DB-specific queries

Collapse
Posted by Eduardo Pérez on
What do you mean?

Adding PL/pgSQL to Oracle or adding PL/SQL to PostgreSQL?

Could anyone with experience in both languages comment the benefits and
drawbacks of either one?

Collapse
Posted by Jeff Davis on
the safest thing is to map __ to . in oracle queries.  Trying to map . to __ but only when it is a function and not a table.column reference is _hard_.

It is not entirely risk free but I think we would see fewer bugs because of this than we now see because we have two
parallel sets of queries when one would suffice.