You are correct, I missed that. In MySQL, functional indices are implemented as ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		sgarland 4 months ago \| parent \| context \| favorite \| on: PostgreSQL Full-Text Search: Fast When Done Right ... You are correct, I missed that. In MySQL, functional indices are implemented as invisible generated virtual columns (and there is no vector index type supported yet that I'm aware of), but Postgres has a more capable approach.

charettes 4 months ago [–]

TIL I wasn't aware MySQL functional indices were implemented using virtual columns [0]

[0] https://dev.mysql.com/doc/refman/8.4/en/create-index.html#cr...

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact