This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
Trigonometric functions
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
Some dialects may not support all trigonometric functions.
Using Settings.transformPatternsTrigonometricFunctions, the following transformations can be achieved:
-- With Settings.transformPatternsTrigonometricFunctions active, this: SELECT SIN(x) / COS(x), COS(x) / SIN(x), 1 / TAN(x), 1 / COT(x) FROM tab; -- ... is transformed into the equivalent expression: SELECT TAN(x), -- SIN(x) / COS(x) COT(x), -- COS(x) / SIN(x) COT(x), -- 1 / TAN(x) TAN(x) -- 1 / COT(x) FROM tab;
Feedback
Do you have any feedback about this page? We'd love to hear it!