The AND, OR, and NOT keywords are PostgreSQL's Boolean operators. These keywords are mostly used to join or invert conditions in a SQL statement, specifically in the WHERE clause and...
May 3, 2013
·
9:00 AM
A mathematical function operates on input values ( numeric ) which are provided as arguments, and return a numeric value as the output of that operation. Mathematical functions operates on numeric...
May 3, 2013
·
9:00 AM
PostgreSQL provided many Mathematical operators for common mathematical conventions. The bitwise operators can be used only with the integer data types.
May 3, 2013
·
9:00 AM
The PostgreSQL MAX function returns the maximum value, specified by expression in a set of aggregated rows.
May 3, 2013
·
9:00 AM
The MIN function determines the smallest of all selected values of a column.
May 3, 2013
·
9:00 AM
The not-null constraint in PostgreSQL ensure that a column can not contain any null value. This is a column constraint. No name can be defined to create a not-null constraint.
May 3, 2013
·
9:00 AM
A query, after executed by PostgrerSQL select statement can optionally be sorted. Sometime for better inspection it is required to comes rows in a sorted order. PostgreSQL ORDER BY will do the job...
May 3, 2013
·
9:00 AM
The PostgreSQL PRIMARY KEY is a column in a table which must contain a unique value which can be used to identify each and every row of a table uniquely. So it can be said that the PRIMARY KEY of...
May 3, 2013
·
9:00 AM
PostgreSQL SELECT statement retrieves data from a single table or multiple tables or views (a virtual table).
May 3, 2013
·
9:00 AM
The PostgreSQL string functions can be used for manipulating and examining various type of queries independently or within a table.
May 3, 2013
·
9:00 AM
