How to set LIMIT within a conditional statement; POSTGRESQL

Question

I want to order the result by id in descending order and then LIMIT the number of rows obtained based on a @condition

ORDER BY id DESC
IF @condition is TRUE THEN  LIMIT 1
ELSE nothing
END IF

Lukasz Szozda · Accepted Answer · 2018-06-25 11:17:04Z

13

You could use CASE:

ORDER BY id DESC
LIMIT CASE WHEN @condition THEN 1 END;

LIMIT NULL is the same as omitting the LIMIT clause

answered Jun 25, 2018 at 11:17

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

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

1 Answer 1