There appears to be no way to set the index order (ASC/DESC) and nulls order (FIRST/LAST). The latter is probably not available in MySQL but is nevertheless part of the SQL standard.
Another major omission is the index access type. In Postgres, this could be heap, btree, hash, gist, gin, spgist or brin. I don't know how portable this is though.
There appears to be no way to set the index order (
ASC/DESC) and nulls order (FIRST/LAST). The latter is probably not available in MySQL but is nevertheless part of the SQL standard.Another major omission is the index access type. In Postgres, this could be
heap,btree,hash,gist,gin,spgistorbrin. I don't know how portable this is though.