Sql

Search

postgres : ERROR: division by zero

SELECT 1.0 / NULLIF(column_that_may_be_zero, 0)

Comment

division by zero postgres

-- avoid division error in Postgres
value/NULLIF(col, 0)  -- if col == 0, NULL will be returned
value/COALESCE(NULLIF(col, 0), 1)  -- if col == 0, value will be returned

Comment

PREVIOUS	NEXT

Code Example
Sql :: how to set a column as unique in sql server
Sql :: mysql date equals to current_date plus days
Sql :: get number of columns sql
Sql :: how to change column name in mysql
Sql :: insert snowflake
Sql :: default number in sql
Sql :: sql server select last row of each item in group by column
Sql :: select columns postgres
Sql :: create temp table in sql
Sql :: mysql auerries to find the name starting with vowel letter
Sql :: WHERE not regex in SQL
Sql :: sqlserver add column
Sql :: oracle all_dependencies
Sql :: change column data type sql
Sql :: postgres integer to serial
Sql :: find number of entries sql
Sql :: sql find second highest salary employee
Sql :: postgres trigger insert into another table
Sql :: update table mysql
Sql :: postgres order by month
Sql :: sql column to row
Sql :: sql server create database
Sql :: sql alchemy or
Sql :: select last n rows mysql
Sql :: mysql query to find duplicate records
Sql :: postgres windows import dump
Sql :: mysql count unique in group statement
Sql :: add foreign key to existing table
Sql :: how to select month from date in sql
Sql :: call function in query sql server

Search

SQL

postgres : ERROR: division by zero

division by zero postgres

ADD CONTENT