3 ms·

It's coming in the Postgres 18. https://www.depesz.com/2025/02/28/waiting-for-postgresql-18-virtual-generated-columns/ https://www.depesz.com/2025/02/28/waiting

• sgarland 1y ago
  Yes (very exciting!), but you won’t be able to index them, and that’s really where they shine, IMO. Still, I’m sure they’ll get there. Maybe they’ll also eventually get invisible columns, though tbf that’s less of a problem for Postgres as it is for MySQL, given the latter’s limited data types.
  • danielheath 1y ago
    You can index arbitrary expressions, though, including indexing the same expression used to define the invisible column, right?