4 ms·
enum does exist in PostgreSQL (which is in the article's URL). But an enum still requires a lookup for the associated value when setting and getting rows, it's
by donarb 8y ago
enum does exist in PostgreSQL (which is in the article's URL). But an enum still requires a lookup for the associated value when setting and getting rows, it's not free.
- jjeaff 8y agoIt's got to be way closer to free than a separate table join. But I did find a good answer hear about the pitfalls of enum in MySQL. Some/most of which would apply in the case of PostgreSQL.
- TylerE 8y agoPostgres joins against small tables are really really efficient. It wouldn't shock me if enums actually were implemented as tables.