Hello,
I'm trying to add 1 week "VIP-status" to all users in a table:
update pref_users set vip = max(vip, now()) + interval '1 week';
but max() doesn't work with timestamps.
Is there maybe still a way to solve it with a one-liner?
Thank youAlex