Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
postgres [2012/03/29 10:27] glaroc |
postgres [2012/04/04 17:15] (current) glaroc |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Introduction to Database Management Systems with PostgreSQL ====== | ====== Introduction to Database Management Systems with PostgreSQL ====== | ||
| + | **Many-to-many** | ||
| + | Solution: additional table with both Keys. | ||
| + | |||
| + | **Hierarchy** | ||
| + | |||
| + | **Recursive relationships** | ||
| ===== Exercise 1 - Import data into PostgreSQL ===== | ===== Exercise 1 - Import data into PostgreSQL ===== | ||
| Line 12: | Line 18: | ||
| ===== Exercise 5 - Functions ===== | ===== Exercise 5 - Functions ===== | ||
| + | [[http://www.postgresql.org/docs/9.1/interactive/functions-math.html| Click here of a list of mathematical functions and operators]] | ||
| - | |ABS()|Return the absolute value| | ||
| - | |ACOS()|Return the arc cosine| | ||
| - | |ASIN()|Return the arc sine| | ||
| - | |ATAN2(), ATAN()|Return the arc tangent of the two arguments| | ||
| - | |ATAN()|Return the arc tangent| | ||
| - | |CEIL()|Return the smallest integer value not less than the argument| | ||
| - | |CEILING()|Return the smallest integer value not less than the argument| | ||
| - | |CONV()|Convert numbers between different number bases| | ||
| - | |COS()|Return the cosine| | ||
| - | |COT()|Return the cotangent| | ||
| - | |CRC32()|Compute a cyclic redundancy check value| | ||
| - | |DEGREES()|Convert radians to degrees| | ||
| - | |EXP()|Raise to the power of| | ||
| - | |FLOOR()|Return the largest integer value not greater than the argument| | ||
| - | |LN()|Return the natural logarithm of the argument| | ||
| - | |LOG10()|Return the base-10 logarithm of the argument| | ||
| - | |LOG2()|Return the base-2 logarithm of the argument| | ||
| - | |LOG()|Return the natural logarithm of the first argument| | ||
| - | |MOD()|Return the remainder| | ||
| - | |OCT()|Return an octal representation of a decimal number| | ||
| - | |PI()|Return the value of pi| | ||
| - | |POW()|Return the argument raised to the specified power| | ||
| - | |POWER()|Return the argument raised to the specified power| | ||
| - | |RADIANS()|Return argument converted to radians| | ||
| - | |RAND()|Return a random floating-point value| | ||
| - | |ROUND()|Round the argument| | ||
| - | |SIGN()|Return the sign of the argument| | ||
| - | |SIN()|Return the sine of the argument| | ||
| - | |SQRT()|Return the square root of the argument| | ||
| - | |TAN()|Return the tangent of the argument| | ||
| - | |TRUNCATE()|Truncate to specified number of decimal places| | ||
| ===== Exercise 5 - Dealing with multiple tables ===== | ===== Exercise 5 - Dealing with multiple tables ===== | ||
