IIRC, index functions can take multiple arguments, it's just that
they cannot take constants. I think the values must all be columns
of the tables. So for example, this should work (seems to at
least create on 7.1beta3):
create table aaa (a int, b int, c text);
create index blah on aaa(substr(c,
Scott Marlowe ([EMAIL PROTECTED]) 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