By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 975 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

table name as a column datatype

P: 20
Hello all

Recently I was playing with column data types and found that you can have a table name as the column's datatype although it looks like an "array object". For ex. if I have table1 and table2, it seems something like the following is possible..

create table table2(id bigint,table1[]);

Am just interested in what are the situations one would go for such an option? Any example or a direction for reading on this topic would be much appreciated.

Thanks a lot.
Jun 14 '08 #1
Share this Question
Share on Google+
1 Reply

P: 20
Hello all,

My bad, i should have mentioned it, am working on postgres. If anyone has used table as a columns datatype I would be glad to hear from you if you could tell me when to go for such an option.

Jul 14 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.