Similar Topics

230+ articles

PostgreSQL-String-function

10+ articles

PostgreSQL-Window-function

10+ articles

PostgreSQL-Date-function

7+ articles

PostgreSQL-function

40+ posts

Popular articles

Recent articles

PostgreSQL - DATE_PART Function

Last updated: 01 February 2021

In PostgreSQL, the DATE_PART() function is used to query for subfields from a date or time value.Syntax: DATE_PART(field, source)In the above syntax the field is an identi ...read more

PostgreSQL-function

PostgreSQL-Date-function

PostgreSQL - ROW_NUMBER Function

Last updated: 16 February 2023

In PostgreSQL, the ROW_NUMBER() function is used to assign a unique integer to every row that is returned by a query.Syntax:ROW_NUMBER() OVER( [PARTITION BY column_1, c...read more

PostgreSQL-function

PostgreSQL-Window-function

PostgreSQL - RANK Function

Last updated: 10 February 2021

In PostgreSQL, the RANK() function is used to assign a rank to each row of the query result set within the specified partition. The rank of the first row within each part...read more

PostgreSQL-function

PostgreSQL-Window-function

Similar Topics

230+ articles

PostgreSQL-String-function

10+ articles

PostgreSQL-Window-function

10+ articles

PostgreSQL-Date-function

7+ articles

PostgreSQL - DATE_TRUNC Function

Last updated: 01 February 2021

In PostgreSQL, DATE_TRUNC Function is used to truncate a timestamp type or interval type with specific and high level of precision.Syntax: date_trunc('datepart', field)The ...read more

PostgreSQL-function

PostgreSQL-Date-function

PostgreSQL - SPLIT_PART Function

Last updated: 16 July 2021

The PostgreSQL SPLIT_PART() function is used to split a string from a specific delimiter and these queries return the nth substring.Syntax: SPLIT_PART(string, delimiter, p ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - REPLACE Function

Last updated: 01 February 2021

In PostgreSQL, the REPLACE function is used to search and replace all occurrences of a string with a new one.Syntax: REPLACE(source, old_text, new_text );Let's analyze the ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - CONCAT_WS Function

Last updated: 08 October 2021

In PostgreSQL, the CONCAT_WS function is used to concatenate strings with a separator. Like the CONCAT function, the CONCAT_WS function is also variadic and ignored NULL v...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL- CONCAT Function

Last updated: 08 February 2021

In PostgreSQL, the CONCAT function is used to concatenate two or more strings into one.Syntax: CONCAT(string_1, string_2, ...)Let's analyze the above syntax:The CONCAT fun...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - LAG Function

Last updated: 21 November 2022

In PostgreSQL, the LAG() function is used to access a row that comes exactly before the current row at a specific physical offset. The LAG() comes in handy while comparing...read more

PostgreSQL-function

PostgreSQL-Window-function

PostgreSQL - FORMAT Function

Last updated: 25 August 2021

In PostgreSQL, the FORMAT() function is used to format arguments based on a format string.Syntax:FORMAT(format_string [, format_argument [, ....] ])Let's analyze the above ...read more

PostgreSQL-function

PostgreSQL-String-function

PostgreSQL - Function Returning A Table

Last updated: 28 August 2020

In this article, we will look into the process of developing functions that returns a table. We will use the film table in the sample database for the demonstration:The fo ...read more

PostgreSQL-function

PostgreSQL - Function Parameters

Last updated: 28 August 2020

PostgreSQL has 4 types of function parameters as listed below:INOUTINOUTVARIADICIN Parameter:To better understand these function parameters let's first define a function o ...read more

PostgreSQL-function

PostgreSQL - NULLIF() Function

Last updated: 28 August 2020

PostgreSQL has a NULLIF function to handle null values. The NULLIF function is one of the most common conditional expressions provided by PostgreSQL.Syntax:NULLIF(argument ...read more

PostgreSQL-function

PostgreSQL - Size of a Table

Last updated: 22 February 2021

In this article, we will look into the function that is used to get the size of the PostgreSQL database table.In this article, we will be using a sample database for refer...read more

PostgreSQL-function

PostgreSQL - Size of a Database

Last updated: 28 August 2020

In this article, we will look into the function that helps us to evaluate the size of a given database. The pg_database_size() function is used to get the size of a databa...read more

PostgreSQL-function