PostgreSQL: lower Function
This PostgreSQL tutorial explains how to use the PostgreSQL lower function with syntax and examples.
Description
The PostgreSQL lower function converts all characters in the specified string to lowercase.
Syntax
The syntax for the lower function in PostgreSQL is:
lower( string )
Parameters or Arguments
- string
- The string to convert to lowercase.
Note
- If there are characters in the string that are not letters, they are unaffected by the lower function.
- See also the upper function.
Applies To
The lower 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 lower function examples and explore how to use the lower function in PostgreSQL.
For example:
postgres=# SELECT lower('Tech on the Net'); lower ----------------- tech on the net (1 row) postgres=# SELECT lower('TechOnTheNet.com is #1'); lower ------------------------ techonthenet.com is #1 (1 row)
Advertisements