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
Another 10 PostgreSQL string functions have discussed with syntax and example in this page.
May 3, 2013
·
9:00 AM
In this page we have discussed last 10 more important string functions with syntax and examples.
May 3, 2013
·
9:00 AM
