In PostgreSQL, the ceiling() function is used for rounding a number up to the nearest integer.
It’s similar to round(), except that it only rounds up. The round() function will round up or down as required.
It’s also similar to floor(), except that floor() rounds down instead of up.
In PostgreSQL, the floor() function is used for rounding a number down to the nearest integer.
It’s basically the opposite of ceiling(), which rounds a number up.
It’s also similar to round(), except that it only rounds down. The round() function will round up or down as required.
In PostgreSQL, the round() function is used for rounding a number.
The function can work in one of two ways, depending on how you use it. You can make it round the number to the nearest integer, or to a specified number of decimal places.
This is determined by the number of arguments you pass to the function when you call it.
Continue readingIn Postgres, the age() function returns the age based on two timestamp or date variables.
The result is returned using years and months, rather than just days.
For example, a result might look like this: 3 years 2 mons 30 days.
Continue readingIn Postgres, to_char() is a data type formatting function that converts its first argument to a string.
The format of the string is determined by the second argument.
The to_char() function can be used to do the following conversions:
In SQLite, iif() is a conditional function that returns the second or third argument based on the evaluation of the first argument.
It’s logically equivalent to CASE WHEN X THEN Y ELSE Z END.
iif() is an abbreviation for Immediate IF.
The iif() function was introduced in SQLite 3.32.0, which was released on 22 May 2020.
Some database management systems (DBMSs) include a feature called generated columns.
Also known as “computed columns”, generated columns are similar to a normal column, except that a generated column’s value is derived from an expression that computes values from other columns.
In other words, a generated column’s value is computed from other columns.
Continue readingSQLite has the ON CONFLICT clause that allows you to specify how to handle constraint conflicts. It applies to UNIQUE, NOT NULL, CHECK, and PRIMARY KEY constraints (but not FOREIGN KEY constraints).
There are five possible options you can use with this clause:
ABORTFAILIGNOREREPLACEROLLBACKThis article provides examples and an explanation of each of these options.
The ON CONFLICT clause is used in CREATE TABLE statements, but it can also be used when inserting or updating data by replacing ON CONFLICT with OR.
SQLite is a widely-used lightweight, embedded relational database management system (RDBMS).
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is largely SQL standards compliant, and it is fully ACID compliant.
Continue readingIn database terms, a CHECK constraint is a type of constraint that checks data before it enters the database.
CHECK constraints help maintain data integrity, because they prevent invalid data entering the database.
Continue reading