Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 47FAA476AD2
	for <pgsql-sql@postgresql.org>; Fri, 18 Oct 2002 13:40:46 -0400 (EDT)
Received: from pd3mo2so.prod.shaw.ca (shawidc-mo1.cg.shawcable.net
	[24.71.223.10]) by postgresql.org (Postfix) with ESMTP id AC5E6476C43
	for <pgsql-sql@postgresql.org>; Fri, 18 Oct 2002 13:40:02 -0400 (EDT)
Received: from pd5mr3so.prod.shaw.ca
	(pd5mr3so-qfe3.prod.shaw.ca [10.0.141.144]) by l-daemon
	(iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12 2002))
	with ESMTP id <0H46006PIUEQZ0@l-daemon> for pgsql-sql@postgresql.org;
	Fri, 18 Oct 2002 11:40:02 -0600 (MDT)
Received: from pn2ml8so.prod.shaw.ca
	(pn2ml8so-qfe0.prod.shaw.ca [10.0.121.152]) by l-daemon
	(iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12 2002))
	with ESMTP id <0H460070MUEQS6@l-daemon> for pgsql-sql@postgresql.org;
	Fri, 18 Oct 2002 11:40:02 -0600 (MDT)
Received: from kimiko (h24-78-132-76.vc.shawcable.net [24.78.132.76])
	by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12
	2002))
	with SMTP id <0H4600INYUEP1G@l-daemon> for pgsql-sql@postgresql.org;
	Fri, 18 Oct 2002 11:40:02 -0600 (MDT)
Date: Fri, 18 Oct 2002 06:58:03 -0700
From: Vernon Wu <vernonw@gatewaytech.com>
Subject: Can I search for an array in csf?
To: pgsql-sql@postgresql.org
Reply-To: vernonw@gatewaytech.com
Message-id: <VQ2YXVB9XVGDGC2WSNJ074ZPNPNOLA8.3db0136b@kimiko>
MIME-version: 1.0
X-Mailer: Opera 6.05 build 1140
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7BIT
X-Priority: 3 (Normal)
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/232
X-Sequence-Number: 9949


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.

Vernon