Re: selecting DB on linux

["Thomas O'Dowd" <tom@example.com>]

On Thu, Jun 14, 2001 at 10:01:15PM +0900, Viktor Pavlenko wrote:
> >>>>> "DC" == Darren Cook <darrenj@example.com> writes:
> 
>     DC> Lots of postgres supporters here (including me). Aren't there
>     DC> any Oracle advocates here to balance things? I've heard Oracle
>     DC> is the best choice once you database gets big enough to need
>     DC> more than one machine.
> 
> I'm not a DB person (they write stored procedures for me;) but while
> doing a small web-based project I noticed that UPDATE in Postgres
> doesn't support subquery in the WHERE clause. It's just an observation
> since I don't know if SQL92 and SQL3 (I think), the standards Postgres
> claims to implement, require it. On the other hand Oracle does easily.

Yep, postgresql still has its quirks... the latest version 7.1 fixed
quite a few of the subquery problems. Don't know if it got this one
though...

That said, the commercial ones have their problems too. Playing with DB2
on linux a year ago had my really frustrated when their JDBC driver was
quietly refusing to work in multi-threaded apps. It worked right away 
when I swapped the database out to postgresql and I later found the problem
on their website. Not sure what it is like these days.

Tom.
-- 
Thomas O'Dowd. - Nooping - http://nooper.com
tom@example.com - Testing - http://nooper.co.jp/labs