On Tue, Sep 17, 2002 at 09:34:08AM +0000, Rafiq Ismail (ADMIN) wrote:
> I'm using postgres and remember having done something ages ago with some
> operator in mysql, although it makes zero sense to me now as to how I did
> it the first time. What I want to do is have a select return a partial
> string from the ith character of a string to the jth character of a
> string. I'd like postgres to filter this partial string and return it to
> me.
Not completed but do you mean something along the lines of:
create table FOO ( content text );
insert into foo values ('I\'m using postgres and remember having done something ages
ago with some');
insert into foo values ('operator in mysql, although it makes zero sense to me now as
to how I did');
insert into foo values ('it the first time. What I want to do is have a select return
a partial');
insert into foo values ('string from the ith character of a string to the jth
character of a');
insert into foo values ('string. I\'d like postgres to filter this partial string and
return it to');
insert into foo values ('me.');
select substring(content from 11 for 4) from FOO;
and you'd like a where clause on the 4 characters?
Chisel
--
e: [EMAIL PROTECTED] | Stick with what you know and travel
w: www.herlpacker.co.uk | light; if you only carry a hammer then
gpg: D167E7FE | all problems are nails.
