sql - Postgres 9.5 ON CONFLICT DO SELECT

e-mallz contact answered on August 17, 2022 Popularity 3/10 Helpfulness 2/10

answer sql - Postgres 9.5 ON CONFLICT DO SELECT

sql - Postgres 9.5 ON CONFLICT DO SELECT

Comment

WITH cte AS (
   INSERT INTO "user"(timestamp, user_id, member_id)
   values ($1, $2, $3)
   ON CONFLICT (user_id, member_id) DO NOTHING
   RETURNING user_id
)
SELECT NULL AS result
WHERE EXISTS (SELECT 1 FROM cte)          -- success
UNION ALL
SELECT id 
FROM "user" 
WHERE user_id = $2 
  AND NOT EXISTS (SELECT 1 FROM cte);     -- conflict

Popularity 3/10 Helpfulness 2/10 Language sql

Source: sqlerrors.com

Tags: conflict select sql

Link to this answer
Share Copy Link

Contributed on Aug 17 2022

e-mallz contact

0 Answers Avg Quality 2/10

sql - Postgres 9.5 ON CONFLICT DO SELECT

Contents

More Related Answers

sql - Postgres 9.5 ON CONFLICT DO SELECT

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.