update.sql 344 B

123456789101112
  1. INSERT INTO code_detail(hash, type, store, value, expiry, used)
  2. VALUES (:hash, :type->>0, :store->>0, :value, :expiry, :used)
  3. ON CONFLICT DO
  4. UPDATE SET
  5. type = excluded.type,
  6. store = excluded.store,
  7. value = excluded.value,
  8. expiry = excluded.expiry,
  9. used = excluded.used
  10. WHERE TRUE
  11. ;
  12. SELECT 'redirect' AS component, '/code.sql' AS link;