Benefit of TEXT with CHECK over VARCHAR(X) in PostgreSQL. Brandur suggests using email TEXT CHECK (char_length(email) <= 255)
to define a column with a length limit in PostgreSQL over VARCHAR(255)
because TEXT
and VARCHAR
are equally performant but a CHECK
length can be changed later on without locking the table, whereas a VARCHAR
requires an ALTER TABLE
with an exclusive lock.
Recent articles
- Maybe Meta's Llama claims to be open source because of the EU AI act - 19th April 2025
- Image segmentation using Gemini 2.5 - 18th April 2025
- GPT-4.1: Three new million token input models from OpenAI, including their cheapest model yet - 14th April 2025