Re: tables in tables

Fernando Benites wrote:

> I want to create a table in a table, that means, if i have a row, in that row are many columns, where one column is a
table(with should we say 20 rows) 
> it is important that the table in the table hsa 20 rows, and new inserting would be the first row in this table, and
thalast one would be deleted. 
> and with each new row of the mother table, it would be create a new child table for this new row.
> How can i do that?

The closest is probably to use arrays in PostgreSQL.  See file:///usr/share/doc/postgresql-7.1.2/html/arrays.html or
similarlocation on your system. 

Plain SQL doesn't support tables as data types.

Often, there is a better way to model the data; one which does not require nested tables.

If not, consider an object oriented database....


Allan.