Re: [SQL] Nested Table in PostgreSQL or some alternative Variants

2005-11-01 Thread Jim C. Nasby
What do you mean by 'nested table'? Maybe arrays will do what you want? Typically (and this applies to other databases as well), this is done using two tables and refferential integrity. IE: CREATE TABLE purchase_order( po_id serial CONSTRAINT purchase_order__po_id PRIMARY KEY

[SQL] Nested Table in PostgreSQL or some alternative Variants

2005-10-31 Thread Thomas Zuberbuehler
Hello there I've a problem. I can't find some information about nested tables in PostgreSQL. Is this Features possible in pgsql or not? * When yes, how i can use and create nested tables with pgsql? * When no, which alternative are there (for same problem definition)? Thank you for help. Gree