Postgres and Open Source Experts

The LEFT() function takes a string and the number of characters to extract as arguments and retrieves the extracted/modified string.

Postgres offers several built-in functions and operators that are used to perform division on different numeric values, such as the “/” operator, DIV() function, MOD() function, etc.

The INITCAP() is a built-in string function that accepts a string as an argument and converts the first letter of every word into uppercase and the remaining letters into lowercase.

To extract the day name from a specific date, you need to pass the date/timestamp as a first argument and a valid day format as the second argument to the “TO_CHAR()” function.

In PostgreSQL, the ORDER BY clause is used with the RANDOM() function to get the random data from large tables.

The ARRAY_AGG() function in Postgres is an aggregate function that takes a column as input and returns an array of values from all the rows in the specified group.

In Postgres, a time zone represents a region of the earth with a uniform standard time. Time zones allow us to convert local time to UTC or vice versa.

In Postgres, the NOW() and CURRENT_TIMESTAMP functions are used to fetch the current date and time with the time zone offset.

Postgres offers a DateTime function named LOCALTIME that retrieves the current time without a timezone. It may or may not accept an optional argument named “precision”.

In Postgres, the ILIKE operator performs the case-insensitive pattern matching on a string. Two wildcards are used to specify a pattern in ILIKE operator: an underscore “_” and a percent sign “%”.