How to use a case statement
19:17 15 Sep 2022

This is my SQL Query

CASE WHEN (1>2) THEN(
    select * from rate limit 10
    )
    ELSE
    (
    select * from rate limit 1
    )

When I use case statement like above, I can get error like below.

ERROR:  syntax error at or near "CASE"
LINE 2: CASE WHEN (1>2) THEN(
        ^
SQL state: 42601
Character: 2

Can anyone help me to solve this

sql postgresql case