4 ms·
Agreed. The thorough support for hierarchical queries is quite tasty, though.
by mcantor 16y ago
Agreed. The thorough support for hierarchical queries is quite tasty, though.
- rst 16y agoThis used to be a strong distinguishing feature, but postgresql has it too as of 8.4, albeit in a somewhat different form (SQL standard "with recursive"; if you want the Oracle "start with ... connect by" syntax, you have to get the EnterpriseDB commercial postgresql fork). Oracle still has features that I don't know where to find in the mainstream open-source competition: among others, support for encrypted on-disk storage, and multi-master write support (as opposed to write-on-master, read-from-mirrors). But a lot of those require an "Enterprise" license, which costs significantly more than the already high license fees for the "standard" edition. (Besides which, if you're building a cluster, you probably want enough control over the physical I/O hardware, for performance reasons, that it doesn't make sense to build it on AWS.)
- tom_b 16y agoThis. I've done (1) nested sets, (2) recursive CTEs, and (3)the magic Oracle fairy dust of CONNECT BY and STARTS WITH. (1) and (2) seem to make my coworkers (and bosses) eyes' glaze over. I think they like (3) because they don't have to worry as much about "code that guy in the corner wrote."
- mcantor 16y agoCONNECT BY/STARTS WITH can be brain-bending, too, if you are doing anything except the most straightforward use case. I found the "pseudocode" on this page under the "Interpreting connect by statements" header to be very enlightening: http://www.adp-gmbh.ch/ora/sql/connect_by.html http://www.adp-gmbh.ch/ora/sql/connect_by.html