Is it possible to cut a string in Select if it exceeds the specified number of characters?

Question

PostgreSQL

Select id, name, text From Texts
Is it possible to truncate "Texts.text" if it is more than 50 characters and add "..." to it?

Answer 1

select
  case 
    when char_length(some_field) > 15 then substring(some_field from 0 for 15) || '...'
    else some_field
  end
from some_table;

Answer 2

Can.
IF ... THEN
char_length, substring
If length is greater than 50, take the first 47 and add "...".