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
Re: How can i create an object in Postgres |
Список | 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 по дате отправления: