From postgresql-general Wed Aug 07 23:54:52 2002 From: "Glen Parker" Date: Wed, 07 Aug 2002 23:54:52 +0000 To: postgresql-general Subject: [GENERAL] Create index ... On ... (lower(field1), lower(field2)) doesn't work? X-MARC-Message: https://marc.info/?l=postgresql-general&m=102876451024433 > Creating indexes on multiple function-modified fields is > illegal... Parser bug? ... Doh!! Sorry... testdb=# select version(); PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96 -- Glen Parker glenebob@nwlink.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html