How to write postgres query

Question

I am new to sql. How can I write query in postgresql for below statement.

select * 
FROM t1 
where (error_id = (123 or 456 or 789) and message_id = 100) 
   or (error_id = 111 and message_id=222)

I believe a better place to start your PostgreSQL journey is by going a little through tutorials and the documentation — Ahmet-Salman
– Ahmet-Salman, Commented Oct 18, 2022 at 18:06
Most likely you need some documentation: postgresql.org/docs/current/index.html — Frank Heikens
– Frank Heikens, Commented Oct 18, 2022 at 18:08
You should use the IN keyword when you're checking for multiple values: error_id IN (123 or 456 or 789). — lemon
– lemon, Commented Oct 18, 2022 at 18:08
@BhanuMittal: Why don't you try to learn SQL instead of random guess work? w3schools.com/sql/sql_where.asp — Frank Heikens
– Frank Heikens, Commented Oct 18, 2022 at 18:20

Isolated · Accepted Answer · 2022-10-18 18:20:59Z

1

Like mentioned in the comments, you should read up on sql and syntax in the postgres documenation. You can also get some practice by using db-fiddle sites, where you can create your own tables, populate them and write queries against them.

The proper query would look like this, where you use IN when including more than one value.

select * 
from t1 
where (error_id in (123, 456, 789) and message_id = 100) 
   or (error_id = 111 and message_id=222)

answered Oct 18, 2022 at 18:20

Isolated

6,4942 gold badges12 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

How to write postgres query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related