dbTalk Databases Forums  

array or not array?

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss array or not array? in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Juergen Mederer
 
Posts: n/a

Default array or not array? - 07-19-2007 , 04:04 PM






Hi all,

i'm a real noob in databasedesign, so i have some questions about it. In
case i want to make a booklist with two tables and the following fields:

owner_table has the fields ID, name, books
book_table has the fields ID, author, title, isbn

normally i would say, this is easy, just filling both tables with data
and linking them together maybe like owner_table.books as a foreign key
linked to book_table.isbn or book_table.ID.

In this way i will have many datasets in owner_table with the same entry
in 'name', depending on how much books this man (or women) has.

But what about an array? Can i use owner_table.isbn as an array-field?
And if this is viable, is it 'good' or 'bad'? And how an i link this
array-field to book_table, because the datatype of the array-field is
not any longer compatible with any field in book_table.

thank you, J.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.