Help with Arrays and References

Поиск
Список
Период
Сортировка
От William N. Zanatta
Тема Help with Arrays and References
Дата
Msg-id 3D175D79.3050409@veritel.com.br
обсуждение исходный текст
Ответы Re: Help with Arrays and References  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: How can i create an object in Postgres  (Suraj Peri <suraj_peri@yahoo.com>)
Список pgsql-general
Hi,

   I'm starting on PostgreSQL so please be patient; =]

   I'm building a book library database in which I have a table
TBL_FORMAT which keeps basic information on various file-formats (ie 1,
PDF, Portable Document Format) and a TBL_BOOKS which I want to reference
TBL_FORMAT. But the column Format inside TBL_BOOKS is an array, as a
book may exist in one or more file types. My doubt is: If I make
something like

   CREATE TABLE "tbl_books" (
   "id_book" int4 DEFAULT nextval('TBL_Books_ID_Books_Seq'::text) NOT NULL,
   "format" _int4 NOT NULL REFERENCES TBL_Format ON_UPDATE CASCADE,
   ...

   will the CASCADE action update my TBL_Books (Format) keeping the
other values in the array or will it erase all and set the new Format value?

   Thanks,

William

--
Perl combines all of the worst aspects of BASIC, C and line noise.
                 -- Keith Packard




В списке pgsql-general по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Some Solaris notes, and an invitation
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Need help on index!!!