5 ms·
> the one thing really holding me back is our use of ENUMs but I don't think that's going to be a big barrier and I hate them anyways Postgres has proper suppo
by pilif 12y ago
> the one thing really holding me back is our use of ENUMs but I don't think that's going to be a big barrier and I hate them anyways
Postgres has proper support for ENUM as defined in the SQL Standard. You have to create a new type and declare it as being an ENUM type:
http://www.postgresql.org/docs/9.4/static/datatype-enum.html http://www.postgresql.org/docs/9.4/static/datatype-enum.html
- joshstrange 12y agoVery interesting! Thanks for the link, even with that I'd rather convert the ENUMs to just VARCHARs as our MVC framework doesn't support ENUMs but it "Just works" because it sends strings to MySQL and MySQL stores them as INTs that map to ENUM values. Because of this the test framework never played nice with creating test DB's that used ENUMs.