Create index ... On ... (lower(field1), lower(field2)) doesn't work?

From: "Glen Parker" <glenebob(at)nwlink(dot)com>
To: "Pg-General" <pgsql-general(at)postgresql(dot)org>
Subject: Create index ... On ... (lower(field1), lower(field2)) doesn't work?
Date: 2002-08-07 23:51:07
Message-ID: 008c01c23e6d$4cc0b410$0b01a8c0@johnpark.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Creating indexes on multiple function-modified fields is illegal...
Parser bug?
Example:

testdb=# create index idx_test on test (lower(field1), lower(field2));
ERROR: parser: parse error at or near ","

Any way around this?

--
Glen Parker
glenebob(at)nwlink(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glen Parker 2002-08-07 23:54:52 Create index ... On ... (lower(field1), lower(field2)) doesn't work?
Previous Message Greg Copeland 2002-08-07 23:27:46 SQL Comments