PostgreSQL: character_length Function
This PostgreSQL tutorial explains how to use the PostgreSQL character_length function with syntax and examples.
Description
The PostgreSQL character_length function returns the length of the specified string.
Syntax
The syntax for the character_length function in PostgreSQL is:
character_length( string )
Parameters or Arguments
- string
- The string to return the length for.
Note
- See also the char_length and length functions.
Applies To
The character_length function can be used in the following versions of PostgreSQL:
- PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4
Example
Let's look at some PostgreSQL character_length function examples and explore how to use the character_length function in PostgreSQL.
For example:
postgres=# SELECT character_length('Tech on the Net'); character_length ------------------ 15 (1 row) postgres=# SELECT character_length('techonthenet.com'); character_length ------------------ 16 (1 row) postgres=# SELECT character_length(''); character_length ------------------ 0 (1 row) postgres=# SELECT character_length(' '); character_length ------------------ 1 (1 row) postgres=# SELECT character_length(NULL); character_length ------------------ <NULL> (1 row)
Advertisements