cannot index functions with multiple arguments
PostgreSQL Bugs List <pgsql-bugs@postgresql.org>
From: pgsql-bugs@postgresql.org
To: pgsql-bugs@postgresql.org
Date: 2001-01-31T15:51:53Z
Lists: pgsql-bugs
Scott Marlowe (smarlowe@ihs.com) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description cannot index functions with multiple arguments Long Description Postgresql version: 7.1beta2 OS: RedHat Linux 7.0 Postgresql allows indexing of functions applied to columns, like so: create index yada on table (lower(column)); but this fails on functions like substr that have multiple arguments. create index yada on table (substr(column,1,4)); fails like so: ERROR: parser: parse error at or near "1" Sample Code Exact code as I typed it in, with response: smarlowe=# create index exten_extension_idx on exten (substr(extension,1,4)); ERROR: parser: parse error at or near "1" I hope this isn't a known bug and I'm reporting it again. No file was uploaded with this report