Not sure I follow—`length(text)` gives the number ...
# off-topich
hko
02/09/2022, 9:34 PMNot sure I follow—`length(text)` gives the number of characters for
textg
garyaustin
02/09/2022, 9:41 PMYou really should ask these questions in one of the help forums as some of us hesitate to offer help in this thread as moderators keep saying not here...
Anyway you will need to do a view with the length as a calculated column, add a calculated column to your table, or use an rpc call to a postgres function and return a table with a select and your length.
You could also just do an array map on the result in javascript...
f
florian-lefebvre
02/09/2022, 9:42 PMMy bad I didn't understand correctly @hko
h
hko
02/09/2022, 9:48 PMappreciate the help regardless, @User 🙂
and @User thank you, calculated column will do then, I believe. (and apologies for ending up in the wrong channel)
hko
02/09/2022, 9:57 PMfor posterior, here's the copy&paste for a calculated column:
alter table tablename add column int generated always as (length(content)) stored;