Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 26EC3475E20 for ; Mon, 30 Sep 2002 08:21:05 -0400 (EDT) Received: from wolff.to (wolff.to [66.93.197.35]) by postgresql.org (Postfix) with SMTP id 5E76E47592C for ; Mon, 30 Sep 2002 08:21:04 -0400 (EDT) Received: (qmail 5393 invoked by uid 500); 30 Sep 2002 12:29:26 -0000 Date: Mon, 30 Sep 2002 07:29:26 -0500 From: Bruno Wolff III To: Mike Sosteric Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] arrays Message-ID: <20020930122926.GA5358@wolff.to> Mail-Followup-To: Mike Sosteric , pgsql-general@postgresql.org, pgsql-sql@postgresql.org References: <200209292127.g8TLRw219816@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.25i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/1371 X-Sequence-Number: 30952 On Sun, Sep 29, 2002 at 18:12:55 -0600, Mike Sosteric wrote: > On Sun, 29 Sep 2002, Bruce Momjian 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] = 'en' It is unusual to want to store arrays in a database. Normally you want to use additional tables instead. For example multilanguage titles is something I would expect to be in a table that had a column referencing back to another table defining the object a title was for, a column with the title and a column with the language.