COS - Revision history

Peter at 10:23, 1 October 2012

2012-10-01T10:23:16Z

2012-10-01T10:22:34Z

2012-10-01T10:17:18Z

2012-07-16T14:42:12Z

2012-07-16T09:55:49Z

2012-07-16T09:53:18Z

2012-07-16T09:51:40Z

2012-07-16T09:51:15Z

2012-07-16T09:49:39Z

2012-07-16T09:48:07Z

@@ Line 13: / Line 13: @@
 <p></p>
 <pre style='width:50ex'>
-   COS(3.14159/3) -> -1.0
+   COS(3.14159/3) -> -0.5
 </pre>
 <div class='ht'>

@@ Line 13: / Line 13: @@
 <p></p>
 <pre style='width:50ex'>
-   COS(3.14159/3) -> 0.5
+   COS(3.14159/3) -> -1.0
 </pre>
 <div class='ht'>

@@ Line 26: / Line 26: @@
 INSERT INTO angle VALUES (3,1.0471);
 </source>
 In this example you return the cosine of each of the angles.
 <source lang='sql' class='def'>
 SELECT id, angle, COS(angle)

@@ Line 36: / Line 36: @@
 <ul>
    <li>[[SIN |SIN function]]</li>
-   <li>[[TAN function]]</li>
+   <li>[[TAN |TAN function]]</li>
 </ul>

@@ Line 24: / Line 24: @@
 INSERT INTO angle VALUES (1,0.7853);
 INSERT INTO angle VALUES (2,0.5235);
-INSERT INTO angle VALUES (3,0.5);
+INSERT INTO angle VALUES (3,1.0471);
 </source>
 In this example you return the cosine of each of the angles.

@@ Line 15: / Line 15: @@
    COS(3.14159/3) -> 0.5
 </pre>
+<div class='ht'>
 <div class=params>schema:scott</div>
 <source lang=sql class='tidy'> DROP TABLE angle</source>
 <source lang=sql class='setup'> CREATE TABLE angle(
-  func VARCHAR(10),
+   id INTEGER,
-  angle INTEGER
+  angle FLOAT);
-   id INTEGER
+INSERT INTO angle VALUES (0,1);
-INSERT INTO angle VALUES (COS,0,1);
+INSERT INTO angle VALUES (1,0.7853);
-INSERT INTO angle VALUES (COS,45,1.732051/2);
+INSERT INTO angle VALUES (2,0.5235);
-INSERT INTO angle VALUES (COS,45,1/1.41421);
-INSERT INTO angle VALUES (COS,60,1/2);
-INSERT INTO angle VALUES (COS,90,NULL);
-INSERT INTO angle VALUES (SIN,0,0);
-INSERT INTO angle VALUES (SIN,30,1/2);
-INSERT INTO angle VALUES (SIN,45,1/1.41421);
-INSERT INTO angle VALUES (SIN,60,1.732051/2);
-INSERT INTO angle VALUES (SIN,90,1);
-INSERT INTO angle VALUES (TAN,0,0);
-INSERT INTO angle VALUES (TAN,30,1/1.732051);
-INSERT INTO angle VALUES (TAN,45,1);
-INSERT INTO angle VALUES (TAN,60,1.732051);
-INSERT INTO angle VALUES (TAN,90,1/0);
 </source>
 In this example you return the cosine of each of the angles.
 <source lang='sql' class='def'>