k1BJjGCX

1CREATE TABLE IF NOT EXISTS test (textt text, ip varchar(22), uid varchar(128));
2CREATE UNIQUE INDEX ON test (uid);
3	
4var db_uid string
5err = 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)
6sreq, err := db.Exec("UPDATE test SET uid = ($1), ip = ($2), textt = ($3) WHERE uid = ($4)", curr_uid, "192.168.1.1", "goodbye", db_uid)
7	
8INSERT INTO test (textt, ip, uid) VALUES ($1, $2, $3) RETURNING (uid) ON CONFLICT (uid) DO NOTHING;