Tag: PostgreSQL

PostgreSQL length function
 

PostgreSQL length function

PostgreSQL length function returns the length of the specified string, expressed in the number of characters. Syntax of the length function in PostgreSQL length( string ) Parameters and...

SQLS*Plus - PostgreSQL upper function 1
 

PostgreSQL upper function

PostgreSQL upper function converts all characters in the specified string to upper case. Syntax of the upper function in PostgreSQL upper( string ) Parameters and function arguments...

PostgreSQL trim function
 

PostgreSQL trim function

PostgreSQL trim function removes all specified characters from the beginning or end of a line. Syntax of trim function in PostgreSQL trim( [ leading | trailing | both ] [ trim_character ] from...

PostgreSQL translate function
 

PostgreSQL translate function

The PostgreSQL translate function replaces a sequence of characters in a string with another set of characters. However, it replaces one character at a time.For example, it replaces the first...

SQLS*Plus - PostgreSQL substring function 1
 

PostgreSQL substring function

PostgreSQL substring function allows extracting substring from a string. Syntax of the substring function in PostgreSQL substring( string [from start_position] [for length] ) Parameters and...

SQLS*Plus - PostgreSQL replace function 1
 

PostgreSQL replace function

The PostgreSQL replace function replaces all occurrences of the specified string. Syntax of the replace function in PostgreSQL replace( string, from_substring, to_substring ) Parameters and...

SQLS*Plus - PostgreSQL position function 1
 

PostgreSQL position function

The PostgreSQL position function returns the substring location in a string. Syntax of the position function in PostgreSQL position ( substring in string ) Parameters and function...

PostgreSQL operator ||
 

PostgreSQL operator ||

PostgreSQL operator || allows combining 2 or more lines together. Syntax for || in PostgreSQL string1 || string2 || string_n Operator parameters and argumentsstring1 - The first line to...

SQLS*Plus - PostgreSQL LTRIM function 1
 

PostgreSQL LTRIM function

The PostgreSQL LTRIM function removes all specified characters on the left side of the line. Syntax of LTRIM function in PostgreSQL ltrim( string, trim_character ) Parameters and function...

SQLS*Plus - PostgreSQL lower function 1
 

PostgreSQL lower function

The PostgreSQL lower function converts all characters of a specified string into a lower case. Syntax of lower function in PostgreSQL lower( string ) Parameters and function arguments...

PostgreSQL character_length function
 

PostgreSQL character_length function

The character_length function in PostgreSQL returns the length of the specified string. The syntax of the character_length function in PostgreSQL character_length( string ) Parameters and...

SQLS*Plus - PostgreSQL char length function 1
 

PostgreSQL char_length function

The char_length function in PostgreSQL returns the length of the specified string. Syntax of char_length function in PostgreSQL char_length( string ) Parameters and function arguments...

SQLS*Plus - PostgreSQL now function 1
 

PostgreSQL now function

The PostgreSQL now function returns the current time and date with the time zone. Syntax of the now function in PostgreSQL now ( ) Parameters and function argumentsThere are no...

SQLS*Plus - PostgreSQL localtimestamp function 1
 

PostgreSQL localtimestamp function

The localtimestamp PostgreSQL function returns the current date and time. Syntax of the PostgreSQL localtimestamp function localtimestamp( [ precision ] ) Parameters and function arguments...

SQLS*Plus - PostgreSQL extract function 1
 

PostgreSQL extract function

PostgreSQL extract function extracts parts from the date. Syntax of the extract function in PostgreSQL extract( unit from date ) Parameters and function argumentsdate - date, timestamp,...

PostgreSQL date_part function
 

PostgreSQL date_part function

PostgreSQL date_part  function extracts parts from the date. The syntax of the date_part function in PostgreSQL date_part( 'unit', date ) Parameters and function argumentsdate - Date,...

 
5