Can I create a partial index as shown in below?

Question

Assume there is a table with 5 columns (id ,first_name (text),last_name(text), product_name(text) and available(boolean)).

CREATE INDEX IF NOT EXISTS "idx-firstname-lower + product_name" 
  ON persons (LOWER(first_name), product_name) WHERE available;

Then why do you ask "can I create such an index" - you obviously can. — , Jul 22 '21 at 07:55
Actually,What I wanted to know was that it was theoretically correct. — KI0821, Jul 22 '21 at 08:31

score 1 · Accepted Answer · answered Jul 22 '21 at 06:58

1

Yes, you can create that index, although I would reconsider the index name. Use a standard conforming name like mytab_lower_firstname_productname_idx.

answered Jul 22 '21 at 06:58

Laurenz Albe

209,280
17
206
263

Can I create a partial index as shown in below?

1 Answers1