PostgreSQL CHARACTER LENGTH
From w3cyberlearnings
Contents |
Postgresql character_length
Returns the number of characters in string.
Syntax character_length
character_length(string)
Example 1
test2=# SELECT character_length('abc');
character_length
------------------
3
(1 row)
test2=# SELECT character_length('apple');
character_length
------------------
5
(1 row)
Example 2
test2=# SELECT user_firstname,
test2-# character_length(user_firstname)
test2-# FROM profile;
user_firstname | character_length
----------------+------------------
Jim | 3
king | 4
Jammi | 5
Bob | 3
|
(5 rows)
Related Links
- string concate
- bit_length
- char_length
- character_length
- lower
- octet_length
- overlay
- position
- substring
- trim
- upper
- ascii
- btrim
