Skip to main content
Documents
Basic SyntaxMath FunctionsDate FunctionsJSON FunctionsDatabasesTables & Schema ManagementString FunctionsTriggersIndexes

PostgreSQL SIN

The `SIN` function in PostgreSQL is a mathematical function used to calculate the sine of a given angle, which is specified in radians. It is commonly utilized in trigonometric calculations within SQL queries to compute sine values for various applications.

Usage

The `SIN` function is employed when you need to determine the sine of an angle, often for scientific, engineering, or statistical purposes. It takes a single argument, the angle in radians, and returns its sine value. The function can handle any numeric type input, such as `integer`, `float`, or `double precision`.

sql
SIN(angle_in_radians)

In this syntax, `angle_in_radians` is a numeric expression representing the angle for which you want to compute the sine.

Examples

1. Basic Usage

sql
SELECT SIN(0.0);

In this example, the sine of `0` radians is calculated, returning a result of `0`.

2. Sine of Pi/2

sql
SELECT SIN(PI()/2);

Here, the sine of π/2 radians is determined, yielding a result of `1`, as expected for this angle.

3. Using SIN in a Table Query

sql
SELECT angle, SIN(angle) AS sine_value
FROM angles_table;

This example calculates the sine of angles stored in the `angles_table` and returns both the original angle and its sine value in the result set.

4. Handling Degrees

sql
SELECT SIN(RADIANS(90));

This example demonstrates how to handle angles in degrees by converting `90` degrees to radians before calculating the sine.

5. Handling NULL Values

sql
SELECT SIN(NULL); -- Returns NULL

This example shows how the `SIN` function handles `NULL` values, returning `NULL`.

Tips and Best Practices

  • Precision matters. Ensure that angles are accurately converted to radians before applying the `SIN` function, as incorrect values can lead to erroneous results.
  • Use with other functions. Combine `SIN` with functions like `COS` for comprehensive trigonometric calculations. For example: 
    sql
  SELECT SIN(PI()/4), COS(PI()/4);
  • Performance considerations. While using trigonometric functions, consider the performance impact on large datasets and optimize queries accordingly.
  • Verify input ranges. Ensure the input values are within the expected range to avoid unexpected results or errors in calculations.
  • Error handling. Be aware that passing `NULL` to `SIN` will return `NULL`, so handle such cases appropriately in your queries.