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  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Mount
Дата:
Сообщение: Re: [JDBC] no way in LargeObject API to detect short read?
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: cannot index functions with multiple arguments