Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 11C794760EF for ; Mon, 21 Oct 2002 05:15:35 -0400 (EDT) Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net [194.217.242.88]) by postgresql.org (Postfix) with ESMTP id E07774760AD for ; Mon, 21 Oct 2002 05:15:08 -0400 (EDT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-30.mail.demon.net with esmtp (Exim 3.35 #1) id 183YeJ-000NlH-0U; Mon, 21 Oct 2002 10:14:59 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 5F82417434; Mon, 21 Oct 2002 10:13:57 +0100 (BST) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id B932317433; Mon, 21 Oct 2002 10:13:56 +0100 (BST) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: vernonw@gatewaytech.com, pgsql-sql@postgresql.org Subject: Re: Can I search for an array in csf? Date: Mon, 21 Oct 2002 10:13:57 +0000 User-Agent: KMail/1.4.3 References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200210211013.58430.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/256 X-Sequence-Number: 9973 On Friday 18 Oct 2002 1:58 pm, Vernon Wu wrote: > One field of a table stores an array of characters in a string fromat as > "a,b,c,d". Is anyway to apply a select statement without using stored > procedure? > > Thanks for your input. Not really, and I can't think any way of accessing an index on this either= .=20 Are you sure you wanted the characters stored this way? Even if the overhea= d=20 of a separate table isn't woth it, you might want to look into arrays and t= he=20 intarray stuff in contrib/ --=20 Richard Huxton