How to include/reference a common bit of code in a function

[c***@yahoo.com]

Hi all,
I have a function that has multiple UNION ALLs. As part of the WHERE condition I need to test if any one of 31 columns is true. So right now I have my function looking something like:

Insert into Table A (column 1, ... column n) (SELECT (column 1, ...column n) from Table BWHERE ( column  A OR column B OR ...repeated 31 times) = trueAND Condition 1AND Condition 2AND Condition 3
UNION ALL
SELECT (column 1, ...column n) from Table CWHERE ( column  A OR column B OR ...repeated 31 times) = trueAND Condition 4AND Condition 5AND Condition 6
UNION ALL
SELECT (column 1, ...column n) from Table DWHERE ( column  A OR column B OR ...repeated 31 times) = trueAND Condition 7AND Condition 8AND Condition 9
UNION ALL repeated about 10 times.
)
My question is there anyway that I can substitute the list of 31 of OR columns (always the same 31 column names) in my WHERE clause  with a "shortcut" so my code is shorter and cleaner. I need to create additional functions for other tables that use the same 31 ORs, so trying to find an easy way to reference this list of ORs across all my functions. Note, the additional WHERE clauses differ for each of the Unions, so I have them numbered 1,2,3 for the first SELECT, 4,5,6 for the second SELECT etc. 
The above is a representation of the function and I have simplified it so I could highlight attention on the above question. 
Thanks! 
Chandru

[Laurenz Albe]

Post by c***@yahoo.com
I have a function that has multiple UNION ALLs. As part of the WHERE condition I
Insert into Table A (column 1, ... column n) (
SELECT (column 1, ...column n) from Table B
WHERE ( column A OR column B OR ...repeated 31 times) = true
[...]
My question is there anyway that I can substitute the list of 31 of OR columns
(always the same 31 column names) in my WHERE clause with a "shortcut" so my code
is shorter and cleaner. I need to create additional functions for other tables that
use the same 31 ORs, so trying to find an easy way to reference this list of ORs
across all my functions. Note, the additional WHERE clauses differ for each of the
Unions, so I have them numbered 1,2,3 for the first SELECT, 4,5,6 for the second SELECT etc.

It would be shorter to write

WHERE TRUE IN (columnA, columnB, ...)

Yours,
Laurenz Albe