JohnH <JohnH(at)atkgib(dot)com(dot)au> writes:> But I want to use a variable in the WHERE option > WHERE activedate < (current date less 188 days)
You're going to be embarrassed...
WHERE activedate < (CURRENT_DATE - 188)
regards, tom lane