Received: from athena.evoserve.com (athena.evoserve.com [210.16.1.33]) by hub.org (8.9.1/8.9.1) with ESMTP id SAA17967 for ; Tue, 19 Jan 1999 18:58:35 -0500 (EST) (envelope-from brianb@athena.evoserve.com) Received: (from brianb@localhost) by athena.evoserve.com (8.8.8/8.7.3) id HAA29660; Wed, 20 Jan 1999 07:58:31 +0800 (GMT+0800) Date: Wed, 20 Jan 1999 07:58:30 +0800 (GMT+0800) From: Brian Baquiran To: frank cc: pgsql-sql@hub.org Subject: Re: [SQL] set type and in clause In-Reply-To: <36A50668.4C0CD67B@x9media.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by hub.org id SAA17968 On Tue, 19 Jan 1999, frank wrote: > how do you create a set type, i.e. an attribute which is, say ´set of > char´; and then you´d want to run some query like > > select . . . from . . . where xxx in yyy > > is such a data type supported by postgresql? do other dbms´s support it? Perhaps you mean an array? If so, it's in Ch. 13 of your postgres docs. Don't know if other dbms support it. Brian