cannot index functions with multiple arguments
| От | pgsql-bugs@postgresql.org |
|---|---|
| Тема | cannot index functions with multiple arguments |
| Дата | |
| Msg-id | 200101311551.f0VFpr438225@hub.org обсуждение |
| Ответы |
Re: cannot index functions with multiple arguments
|
| Список | 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
В списке pgsql-bugs по дате отправления: