Postgres query issues

Question

I'm not sure why this structure is not working. This is my first time working with postgres and was hoping someone could help me.

SELECT * FROM "friends" WHERE "from" = '1' OR "to" = '1' AND "status" = '1'

It returns all values where from where "from" is = 1 and "to" = 1 rather than one or the other where "status" is = 1

I hope that isn't too confusing.

Thanks.

jsalonen · Accepted Answer · 2013-08-06 06:55:05Z

3

OR operator has lower precedence than AND [1]. As a result, the expression is evaluated as follows:

(
    "from" = '1'
)
OR
(
    "to" = '1'
    AND
    "status" = '1'
)

What you probably want instead is:

SELECT * FROM "friends" WHERE ("from" = '1' OR "to" = '1') AND "status" = '1'

answered Aug 5, 2013 at 22:57

jsalonen

30.8k15 gold badges93 silver badges111 bronze badges

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

1 Answer 1