SHARE
TWEET

Untitled

a guest Jun 17th, 2019 56 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE foo ( a int PRIMARY KEY, b int );
  2.      
  3. INSERT INTO foo
  4.   SELECT 5 AS z
  5. ON CONFLICT (a)
  6. DO UPDATE SET b = z;
  7.      
  8. ERROR:  column "z" does not exist
  9. LINE 4:     DO UPDATE SET b = z;
  10.                               ^
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top