News for hackers. Stuff that matters.

A comment on Cost of a Join. Parent comment

Re:Cost of a Join by entee on Tuesday August 14, 2018 @06:41PM (#17762541)
Possibly because ENUM column types don't seem to exist in all SQL databases? I could be wrong though...
[ Parent | on HN ]
Re:Cost of a Join by craftyguy on Tuesday August 14, 2018 @06:44PM (#17762553)
ENUM is in mysql/mariadb. Not sure about oracle or some of the more obscure ones..
[ Parent | on HN ]
Re:Cost of a Join by nerdponx on Tuesday August 14, 2018 @06:48PM (#17762573)
Postgres has it: https://www.postgresql.org/docs/current/static/datatype-enum...
[ Parent | on HN ]
Re:Cost of a Join by craftyguy on Tuesday August 14, 2018 @06:54PM (#17762608)
Yea I assumed Postgres was covered by OP's suggestion to use ENUM.
[ Parent | on HN ]
Re:Cost of a Join by entee on Tuesday August 14, 2018 @06:54PM (#17762612)
Just poking around in docs, seems first added in 8.3?
[ Parent | on HN ]
Re:Cost of a Join by emmelaich on Tuesday August 14, 2018 @06:57PM (#17762629)
You can just make an other table and map a few integers to the statuses.

It's another join but I wouldn't think so much difference over the 'lookup' required for proper ENUM support?

[ Parent | on HN ]