Re: [SQL] [GENERAL] arrays

2002-09-30 Thread Mike Sosteric
t; > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > Mike Sosteric <[EMAIL PROTECTED]> Managing Editor, EJS <http://www.sociology.org/> Department of Global and Soc

Re: [SQL] [GENERAL] arrays

2002-09-30 Thread Mike Sosteric
take the relational approach, post some sample problems here and > people can help you with how to represent XML data relationally. > > -- > -Josh Berkus > Aglio Database Solutions > San Francisco > > Mike Sosteric <[EMAIL PROTECTED]> Managing Editor,

Re: [SQL] [GENERAL] arrays

2002-09-30 Thread Mike Sosteric
ar ago, when > there was nothing production-quality in existence. But I don't know what > the situation is now. > > -- > -Josh Berkus > Aglio Database Solutions > San Francisco > > > ---(end of broadcast)--

Re: [SQL] [GENERAL] arrays

2002-09-30 Thread Mike Sosteric
ike Cache'). > > Good luck. > > -Josh Berkus > > > > Mike Sosteric <[EMAIL PROTECTED]> Managing Editor, EJS <http://www.sociology.org/> Department of Global and Social Analysis Executive Director, ICAAP <http://www.icaap.org/> Athabasca Un

Re: [SQL] [GENERAL] arrays

2002-09-30 Thread Mike Sosteric
On Mon, 30 Sep 2002, Bruno Wolff III wrote: > > 3) can you do selects on only a portion of a multidimensional array. That > > is, if you were storing multilanguage titles in a two dimensional array, > > > > [en], "english title" > > [fr], "french title" > > > > could you select where title[0]

Re: [SQL] [GENERAL] arrays

2002-09-29 Thread Mike Sosteric
On Sun, 29 Sep 2002, Bruce Momjian wrote: Apologies in advance if there is a more appropriate list. We are currently developing a database to host some complicated, XMl layered data. We have chosen postgres because of its ability to store multidimensional arrays. We feel that using these will a