Re: [BUGS] cannot index functions with multiple arguments

2001-01-31 Thread Stephan Szabo
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,

[BUGS] cannot index functions with multiple arguments

2001-01-31 Thread pgsql-bugs
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