VMWare has invested quite a bit of work into PostgreSQL, and employs a few big names in the community. That said, I know nothing about it myself, and can't answer your question regarding it:)
I'm willing to be corrected here, but I understand CONNECT BY was Oracle's way of making recursive queries before the SQL standard invented them. Oracle and PostgreSQL (and presumably others) support standard recursion now.
Postgres also has default function parameters, and extensions which sorta kinda but not really approximate Oracle's packages.
There's more to a database than simply speed. There's transactions, rich data types, index types that support those rich data types (you can only us a b-tree when your data types come from a metric space, hence, for instance, PostgreSQL's GIN and GiST index types), a standardized (if somewhat arcane and problematic) query language...
Slashdot Mirror
VMWare has invested quite a bit of work into PostgreSQL, and employs a few big names in the community. That said, I know nothing about it myself, and can't answer your question regarding it :)
Everyone should love transactional DDL.
I'm willing to be corrected here, but I understand CONNECT BY was Oracle's way of making recursive queries before the SQL standard invented them. Oracle and PostgreSQL (and presumably others) support standard recursion now. Postgres also has default function parameters, and extensions which sorta kinda but not really approximate Oracle's packages.
There's more to a database than simply speed. There's transactions, rich data types, index types that support those rich data types (you can only us a b-tree when your data types come from a metric space, hence, for instance, PostgreSQL's GIN and GiST index types), a standardized (if somewhat arcane and problematic) query language...