Hello. How do you create an index for only some of the rows in a table? I read in the docs: "The expression used in the WHERE clause can refer only to columns of the underlying table, but it can use all columns, not just the ones being indexed. Presently, subqueries and aggregate expressions are also forbidden in WHERE. The same restrictions apply to index fields that are expressions. " So until this changes, can you just add a boolean field to tell if the column should be used in the index, and then run "create index .... where use_in_index = true" or are there other (better?) ways of doing this? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
