Re: Using a variable in sql in a function

you could possibly do it like this.

FOR o in SELECT distinct(col_id) as id
    FROM table1
    JOIN table2
    ON col_id = t2_t1_id
   WHERE 
     CASE  period_type  
       WHEN 'CURRENT' THEN field1 IS NULL
       WHEN 'old'     THEN field1 IS NOT NULL

...etc...

     END
   LOOP