From: Richard Huxton <dev@archonet.com>
To: vernonw@gatewaytech.com
To: pgsql-sql@postgresql.org
Subject: Re: Can I search for an array in csf?
Date: Mon, 21 Oct 2002 10:13:57 +0000
Message-ID: <200210211013.58430.dev@archonet.com> (raw)
In-Reply-To: <VQ2YXVB9XVGDGC2WSNJ074ZPNPNOLA8.3db0136b@kimiko>
References: <VQ2YXVB9XVGDGC2WSNJ074ZPNPNOLA8.3db0136b@kimiko>
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.
Are you sure you wanted the characters stored this way? Even if the overhead
of a separate table isn't woth it, you might want to look into arrays and the
intarray stuff in contrib/
--
Richard Huxton
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, vernonw@gatewaytech.com
Subject: Re: Can I search for an array in csf?
In-Reply-To: <200210211013.58430.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox