Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE users SET membershipexpires =
- CASE membershipexpires
- WHEN membershipexpires IS NULL THEN CURRENT_TIMESTAMP
- WHEN membershipexpires <= CURRENT_TIMESTAMP THEN CURRENT_TIMESTAMP
- ELSE membershipexpires
- END + interval '31 days', WHERE uid=1
Add Comment
Please, Sign In to add comment
