Truncating strings
In the previous exercise, you calculated the length of the description column and noticed that the number of characters varied but most of the results were over 75 characters. There will be many times when you need to truncate a text column to a certain length to meet specific criteria for an application. In this exercise, we will practice getting the first 50 characters of the description column.
Este exercício faz parte do curso
Functions for Manipulating Data in PostgreSQL
Instruções do exercício
- Select the first 50 characters of the
descriptioncolumn with the aliasshort_desc
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
SELECT
-- Select the first 50 characters of description
___(___, ___) AS ___
FROM
film AS f;