Postgres Pro
Downloads
Home   >   mailing lists

Create index ... On ... (lower(field1), lower(field2)) doesn't work? - Mailing list pgsql-general

From Glen Parker
Subject Create index ... On ... (lower(field1), lower(field2)) doesn't work?
Date
Msg-id 008c01c23e6d$4cc0b410$0b01a8c0@johnpark.net
Whole thread Raw
Responses Re: Create index ... On ... (lower(field1), lower(field2)) doesn't work?  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Tree view 
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@nwlink.com

pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: SQL statement to set next serial value to max of a table?
Next
From: "Glen Parker"
Date:
Subject: Create index ... On ... (lower(field1), lower(field2)) doesn't work?