'postgresql change index order

I created an index as follows:

CREATE INDEX index_name_desc_idx
          ON table_name
       USING btree (updated_at ASC)

now: ASC was an error, I need to change it to DESC. I'm trying several things with ALTER INDEX however nothing seems to work and I'm afraid the only thing to do is to remove the index and recreate it. Is there a way to edit the index ordering?

sqlpostgresqlindexing


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions