IN vs EXIIST
От | Jean-Christian Imbeault |
---|---|
Тема | IN vs EXIIST |
Дата | |
Msg-id | 3D893914.5030401@mega-bucks.co.jp обсуждение исходный текст |
Ответы |
Re: IN vs EXIIST
Re: IN vs EXIIST Re: IN vs EXIIST |
Список | pgsql-general |
I find myself writing a lot of queries with this pattern: select distinct key1 from A where id not it (select distinct key1 from A where x='false'); The reason being that key1 is not a primary key (key1, key2 is the primary key). i.e. I have a table like this key1 key2 x ------------------ a 1 t a 2 t a 3 f b 1 t b 2 t b 3 t c 3 t c 4 f So basically I want key1 values for which all the X's are true. I've seen many posts saying that using IN is not optimal and replacing it with EXISTS is much better. I've read the only docs but I can't understand the difference between the two or how to convert. Can someone point me to some other docs or explain to me how to convert? Or is my table schema wrong? Thanks! Jc
В списке pgsql-general по дате отправления: