• Home
• tech.aroma
• aroma-data-operations
• 2.1
• source code
• add_user_device.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

tech.aroma.sql.inserts.add_user_device.sql Maven / Gradle / Ivy

------------------------------------------------------------------------------
-- ADDS A NEW DEVICE
------------------------------------------------------------------------------

INSERT INTO user_preferences (user_id, serialized_devices)
VALUES (?, ARRAY[?])
ON CONFLICT (user_id)
    DO UPDATE
        SET serialized_devices = user_preferences.serialized_devices || EXCLUDED.serialized_devices