4 ms·
Both Oracle and Postgres have objects and collections. This allows you to build hierarchical structures. Postgres unfortunately doesn't allow for recursive stru
by zapov 13y ago
Both Oracle and Postgres have objects and collections. This allows you to build hierarchical structures.
Postgres unfortunately doesn't allow for recursive structures ;(
If you are interested in how to do it take a look here: https://blog.dsl-platform.com/postgres-bridge-between-worlds/ https://blog.dsl-platform.com/postgres-bridge-between-worlds...
- jacques_chester 13y agoIt should be noted that Oracle's object types are a feature of PL/SQL, their imperative programming language. PostgreSQL's concept of object-relational databases is baked into the SQL. Into the logical model of the data itself. Put another way: Oracle doesn't have table inheritance.
- zapov 13y agoWe are using Oracle object types in plain SQL, so no, they are not PL/SQL exclusive. But yeah, you can do a lot less with them outside of PL/SQL.
- jacques_chester 13y agoRight, you're right, I overlooked CREATE TABLE OF.