IF statement in Postgresql

Question

I have a table with feed for our system

it's look like this:

feed_type_id - represent type of object that is stored in different table (article or job_post)

object_id is the object ID itself, but I don't have a clue if this object is still active. So I have get all active id for different type of object, but when I am trying to build query with IF statement something like this

SELECT * 
FROM feeds 
WHERE "owner_id" in (2, 4, 1356) 
  AND object_id IN ( IF `feed_type_id` = 1 THEN (2,3,23,33) ELSE (4,5,77,33) end if)

it's not working.

Can someone give me an idea how to do this?

ig0774 · Accepted Answer · 2016-02-02 10:45:36Z

3

IF statements are not part of the SQL language, but part of the procedural language. As such, you can't use them directly in queries.

The query you're looking for is something like this:

SELECT * 
FROM feeds 
WHERE 
    "owner_id" in (2, 4, 1356) AND 
    (
        ("feed_type_id" = 1 AND "object_id" IN (2, 3, 23, 33)) OR
        ("feed_type_id" != 1 AND "object_id" IN (4, 5, 77, 33))
    )

answered Feb 2, 2016 at 10:45

ig0774

41.6k3 gold badges61 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vivek S. · Accepted Answer · 2016-02-02 12:50:56Z

3

You can use CASE expression like this

SELECT * 
FROM feeds 
WHERE "owner_id" IN (2, 4, 1356) 
AND object_id    IN (CASE 
                         WHEN "feed_type_id" = 1 THEN (2,3,23,33) 
                         ELSE (4,5,77,33) 
                     END)

edited Feb 2, 2016 at 12:50

user330315

answered Feb 2, 2016 at 11:02

Vivek S.

22.3k9 gold badges71 silver badges87 bronze badges

1 Comment

Snifff Over a year ago

Documentation: Conditional Expressions in PostgreSQL

Collectives™ on Stack Overflow

IF statement in Postgresql

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related