IF-THEN-ELSE statements in postgresql

user2311028 Published at Java

user2311028

I'm looking to write a postgresql query to do the following :

if(field1 > 0,  field2 / field1 , 0)

I've tried this query, but it's not working

if (field1 > 0)
then return field2 / field1 as field3
else return 0 as field3

thank youu

Joseph Victor Zammit

As stated in PostgreSQL docs here:

The SQL CASE expression is a generic conditional expression, similar to if/else statements in other programming languages.

Code snippet specifically answering your question:

SELECT field1, field2,
  CASE
    WHEN field1>0 THEN field2/field1
    ELSE 0
  END 
  AS field3
FROM test

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2020-10-19

Comments

0 comments

From Dev

If and if else statements working, but not else

From Dev

IF statements made redundant by ELSE statements

From Dev

Using namespace in if / else statements

From Dev

Using multiple else if statements

From Dev

Angularjs if/else statements

From Dev

Working with multiple if else statements

From Dev

Multiple if and else statements

From Dev

Return a function for IF ELSE IF statements

From Dev

Haskell if then else with "two statements"

From Dev

Bash script - if and else if statements

From Dev

If else statements with size of split

From Dev

Prolog without if and else statements

From Dev

Pythonic alternatives to if/else statements

From Dev

One 'else' for nested 'if' statements

From Dev

Is there an alternative to using IF / ELSE statements

From Dev

If Else VS Multiple If Statements

From Dev

Python: If-else statements

From Dev

If/Else Statements In Batch

From Dev

For loops and else statements in Python

From Dev

Trying to condense else if statements

From Dev

Refactor If/Else Statements

From Dev

Replacing if else statements

From Dev

IF/Else statements on attribute

From Dev

nested if else statements in python

From Dev

Reduce number of if else statements?

From Dev

Java Optional - If Else Statements

From Dev

Angularjs if/else statements

From Dev

Pythonic alternatives to if/else statements

From Dev

Set if else statements PDO

Related Related

Article