Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS test (textt text, ip varchar(22), uid varchar(128));
- CREATE UNIQUE INDEX ON test (uid);
- var db_uid string
- err = db.QueryRows("INSERT INTO test (textt, ip, uid) VALUES ($1, $2, $3) ON CONFLICT (uid) DO NOTHING", "hello", "192.168.0.1", curr_uid).Scan(&db_uid)
- sreq, err := db.Exec("UPDATE test SET uid = ($1), ip = ($2), textt = ($3) WHERE uid = ($4)", curr_uid, "192.168.1.1", "goodbye", db_uid)
- INSERT INTO test (textt, ip, uid) VALUES ($1, $2, $3) RETURNING (uid) ON CONFLICT (uid) DO NOTHING;
Add Comment
Please, Sign In to add comment