Tag: PostgreSQL

PostgreSQL round function
 

PostgreSQL round function

PostgreSQL round function returns a number rounded to a certain number of decimal places. Syntax of the round function in PostgreSQL round( number, [ decimal_places_id ] ) ) Parameters and...

PostgreSQL random function
 

PostgreSQL random function

PostgreSQL random function can be used to return a random number or a random number within a range. Syntax of the random PostgreSQL function random( ) Parameters and function arguments...

PostgreSQL power function
 

PostgreSQL power function

PostgreSQL power function returns the value of m, which is elevated to the n-th degree. Syntax of the power function in PostgreSQL power( m, n ) Parameters and function argumentsm - Base...

PostgreSQL mod function
 

PostgreSQL mod function

PostgreSQL mod function returns the residue from n divided by m. Syntax of the mod function in PostgreSQL mod( n, m ) Parameters and function argumentsn - A numeric value, the rest of...

PostgreSQL min function
 

PostgreSQL min function

The min function in PostgreSQL returns the minimum value of the expression. Syntax of the min function in PostgreSQL SELECT min(aggregate_expression_id) FROM tabs [WHERE conds];Or the...

PostgreSQL MAX function
 

PostgreSQL MAX function

PostgreSQL MAX function returns the maximum value of the expression. Syntax of the max function in PostgreSQL SELECT max(aggregate_expression_id) FROM tabs [WHERE conds];Or the syntax of...

PostgreSQL COUNT function
 

PostgreSQL COUNT function

The PostgreSQL COUNT function returns the number of expressions. Syntax of the count function in PostgreSQL SELECT count(aggregate_expression_id) FROM tabs [WHERE conds];Or the syntax of...

PostgreSQL CEILING function
 

PostgreSQL CEILING function

The PostgreSQL CEILING function returns the smallest integer value, which is greater than or equal to a number. Syntax of the ceiling function in PostgreSQL ceiling( number ) Parameters and...

PostgreSQL CEIL function
 

PostgreSQL CEIL function

The PostgreSQL CEIL function returns the smallest integer value, which is greater than or equal to a number. Syntax of CEIL function in PostgreSQL ceil( number )Parameters and function...

PostgreSQL avg function
 

PostgreSQL avg function

The PostgreSQL avg function returns the average value of the expression. Syntax of avg function in PostgreSQL SELECT avg(aggregate_expression) FROM tables [WHERE conditions];Or the...

SQLS*Plus - PostgreSQL abs function 1
 

PostgreSQL abs function

The abs function in PostgreSQL returns the absolute value of the number. Syntax of abs function in PostgreSQL abs( number ) Parameters and function argumentsnumber - A number for...

PostgreSQL to_timestamp function
 

PostgreSQL to_timestamp function

The PostgreSQL to_timestamp function converts a string into a timestamp. Syntax of the to_timestamp function in PostgreSQL to_timestamp( string1, format_mask ) Parameters and function...

PostgreSQL to_number function
 

PostgreSQL to_number function

The PostgreSQL to_number function converts a string into a number. Syntax of to_number function in PostgreSQL to_number( string1, format_mask ) Parameters and function argumentsstring1 -...

PostgreSQL to_date function
 

PostgreSQL to_date function

The to_date function in PostgreSQL converts a string into a date. Syntax of the to_date function in PostgreSQL to_date( string1, format_mask ) Parameters and function argumentsstring1 -...

PostgreSQL to_char function
 

PostgreSQL to_char function

PostgreSQL to_char function converts a number or date to a string. Syntax of to_char function in PostgreSQL to_char( value, format_mask ) Parameters and function argumentsvalue - A...

PostgreSQL string functions
 

PostgreSQL string functions

In PostgreSQL there are many different string functions designed for formatting, analyzing, and comparing strings.These include both SQL92 standard functions and non-standard PostgreSQL...

 
4