Postgres Pro
Downloads
Home   >   mailing lists

Equivalent of or condition in where clause - Mailing list pgsql-admin

From Firthouse banu
Subject Equivalent of or condition in where clause
Date
Msg-id CAK_Ha4xs9Riv5OyDSyYGTY=nO5EKiACGnbm4hm8wScwxppbgjA@mail.gmail.com
Whole thread Raw
Responses Re: Equivalent of or condition in where clause
List pgsql-admin
Tree view
Hi all, 

Need a suggestion. I have a update query in Postgres which is equivalent to below example. Since query is having multiple or conditions and our tables are very large it’s taking forever to run. Can you guys suggest me what can be replaced with or condition in below example.

Update table_name IA set 
Column_1 = SC. Column_1,
Column_2 = SC. Column_2,
Column_3 = SC. Column_3
From (select statement ) SC
Where 
IA. Column4=! SC. Column4 or 
IA.column5  = ! SC. Column5 or 
IA.column6 = ! SC. Column6 or
IA.column7 = ! SC. Column7
And IA. Column8 = SC. Column8 
And IA. Column9 = SC. Column9;

Thanks 





pgsql-admin by date:

Previous
From: Sachin Kumar
Date:
Subject: Re: work_mem
Next
From: Julien Rouhaud
Date:
Subject: Re: Equivalent of or condition in where clause