Index on substring?

From: Jeff Eckermann <jeckermann(at)verio(dot)net>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Index on substring?
Date: 2000-10-11 19:55:16
Message-ID: 08CD1781F85AD4118E0800A0C9B8580B094727@NEZU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I thought this was possible, but searching the archives & docs I can't find
any reference to it...
Am I doing something wrong?

jeffe(at)kiyoko=> psql -V
psql (PostgreSQL) 7.0.0

jeffe(at)kiyoko=> uname -a
FreeBSD kiyoko.la.verio.net 4.0-STABLE FreeBSD 4.0-STABLE #0: Thu Apr 27
10:44:07 CDT 2000 root@:/usr/src/sys/compile/KIYOKO i386

extracts=# create index c_namesum_i on customers (substr
(bill_company,1,5));
ERROR: parser: parse error at or near "1"
extracts=# select substr (bill_company, 1, 5) from customers limit 10;
substr
--------
RoadW
Beliz
Radio
Trill
R2000
Data
Inter
AEC M
G2 Gr
MindB
(10 rows)

extracts=# create index c_namesum_i on customers (substring(bill_company
from 1 for 5));
ERROR: parser: parse error at or near "substring"
extracts=# select substring (bill_company from 1 for 5) from customers limit
10;
substr
--------
RoadW
Beliz
Radio
Trill
R2000
Data
Inter
AEC M
G2 Gr
MindB
(10 rows)

extracts=#

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Haberlach 2000-10-11 20:52:17 Re: R: PostgreSQL book
Previous Message Alex Pilosov 2000-10-11 19:50:54 Re: Re[2]: Pg.pm question