Suggestion to improve query performance of data validation in proc. - Mailing list pgsql-admin

Hi Team,
Thanks for your support.

Could you please suggest on below query.

We have multiple long procs that are having 100s of data validations and currently we have written as below.

***********

if (SELECT 1  FROM SCHEMA.TABLE WHERE column=data AND column=data) then
statements
etc..

***********

Are there any other ways to validate the data, which will help us to improve the performance of the query?.

Thanks for your support.

Regards,
PostgAnn.