Fw: Arrays
От | Bob Pawley |
---|---|
Тема | Fw: Arrays |
Дата | |
Msg-id | 011c01c622ae$814d52a0$ac1d4318@owner обсуждение исходный текст |
Список | pgsql-general |
----- Original Message ----- From: "Bob Pawley" <rjpawley@shaw.ca> To: "Karsten Hilbert" <Karsten.Hilbert@gmx.net> Sent: Thursday, January 26, 2006 11:26 AM Subject: Re: [GENERAL] Arrays > Because with arrays I can include other information such as pointers to > conversion factors and hopefully implement systems more easily with all > pertinent information tied to a single source (single column). > > Bob > ----- Original Message ----- > From: "Karsten Hilbert" <Karsten.Hilbert@gmx.net> > To: <pgsql-general@postgresql.org> > Sent: Thursday, January 26, 2006 11:00 AM > Subject: Re: [GENERAL] Arrays > > >> On Thu, Jan 26, 2006 at 10:15:22AM -0800, Bob Pawley wrote: >> >>> I would like to make a table of 20 plus columns the >>> majority of columns being arrays. >>> >>> The following test works. The array will hold up to five >>> characteristics of each parameter including the unit of >>> measurement used. Using traditional methods I would need six >>> columns to accomplish the same end (Min, Max, Norm plus a >>> unit column for each). >> And why would that be undesirable ? >> >> Karsten >> -- >> GPG key ID E4071346 @ wwwkeys.pgp.net >> E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 6: explain analyze is your friend >
В списке pgsql-general по дате отправления: