SELECT * FROM table1 WHERE column1 = $1 AND ( $2 IS NULL OR column2 = $2 );
SELECT * FROM table1 WHERE column1 = $1 AND ( $2::text IS NULL OR column2 = $2::text );