Question : I have a several big tables, and enum in each of them (example): ENUM (‘webmasters’, ‘stackexchange’, ‘stackoverflow’) Documenation […]
Tag: enum
How does MariaDB handle ENUM types used in FOREIGN KEY constraints?
Question : Off the heels of this question, How does MySQL handle joins on ENUMs? How does MySQL work if […]
Is it a bad practice to query pg_type for enums on a regular basis?
Question : In Postgres, I’m thinking of query pg_type for an up-to-date list of enumerations I’m using on a regular […]
Does the collation of ENUM columns impact their size?
Question : What does it mean when we say that an ENUM has a charset of utf8mb4, versus latin1? My […]
PostgreSQL ignores implicit casts in some situations
Question : The setup (tried only on PostgreSQL 9.6): CREATE TYPE MY_ENUM AS ENUM (‘a’, ‘b’); CREATE CAST (CHARACTER VARYING […]
Using PostgreSQL to hold an array of data
Question : I am trying to use a postgreSQL data base column to store values from an array (or point […]
How does MariaDB handle joins on ENUMs?
Question : I’m just wondering because MySQL ENUMs are essentially tied to the table, how do they handle JOINs if […]
How do I query PostgreSQL enums like in MySQL?
Question : With the following table in MySQL: CREATE TABLE bob(foo ENUM(‘a’,’b’,’c’)); INSERT INTO bob (foo) VALUES (‘a’),(‘b’),(‘c’),(‘a’),(‘a’); SELECT * […]
Using value of a column in another table for ENUM/SET values
Question : I have two tables tbl_events with a column location_id. Then I have a table specifically to hold locations […]
One-to-many dictionary (lookup) table vs varchar vs enum?
Question : Imagine we have orders table, and an order has a status. Which of these three options is the […]