sql - update all duplicate rows with different values in pgsql -


i need update duplicate rows different values in same table. table is

table(id, phoneid(int), deviceid(int), userid(int))

there records same deviceid or phoneid. example

id   phoneid   deviceid    userid 1    23        3434        1235 2    23        5453        235   <---- same phoneid 1 record  3    43        5453        2343  <---- same deviceid 2 record 4    23        3434        6347  <---- same deviceid , phoneid 1 record

what need change - if phoneid not unique, set phoneid userid(from row). same @ deviceid. (if deviceid not unique, set deviceid userid) final result should this

id   phoneid   deviceid    userid 1    23        3434        1235 2    235       5453        235   <---- phoneid changed userid 3    43        2343        2343  <---- phoneid changed userid 4    6347      6347        6347  <---- phoneid , deviceid changed userid

just update duplicated phoneids , duplicated deviceids (assuming table name "t")

update t set phoneid=userid (select count(*),phoneid t group phoneid having count(*)>1) foo t.phoneid=foo.phoneid; update t set deviceid=userid (select count(*),deviceid t group deviceid having count(*)>1) foo t.deviceid=foo.deviceid;

Comments

Post a Comment

Popular posts from this blog

go - serving up pdfs using golang -

Image
just wondering if guys can code. it works serving images not pdf brochure. in advance func main(){ http.handlefunc("/", func(w http.responsewriter, r *http.request){ filename := "/var/www/filedipenser/brochure.pdf" streampdfbytes, err := ioutil.readfile( filename ) if err != nil { fmt.println(err) os.exit(1) } b := bytes.newbuffer(streampdfbytes) w.header().set("content-type", "application/pdf") if _, err := b.writeto(w); err != nil { fmt.fprintf(w, "%s", err) } w.write([]byte("pdf generated")) }) err := http.listenandserve(":4111", nil) if err != nil { log.fatal("listenandserve: ", err) fmt.println(err) } } the code bit inefficient appears working. however, pdf viewers might sensitive extraneous output adding end of http response stream...
Read more

python - Best design pattern for collection of objects -

i have following architecture: +-----------------+ | collection | | | | | | | | | +-----------------+ | ^ | | create() | | | | v | getitem(b) +------------+ | | item | | | | | | +------+ | | +------------+ a class managing collection of items, creates items. , these items may need other items collection. the actual code in python, , collection passes parameter created item . see it, bad practice. improvement can see pass few functions of collection needed item , instead of whole instance. for example: class collection: getitem(self, id): ... createitem(self, id): item = item(id, self) # <-- pass self ... class item: __init__(self, id, col): ... col.getite...
Read more

how to add preprocess loader in webpack 2 -

i trying add preprocess loader in webpack 3. have installed successfully. not working here's webconfing file var debug = process.env.node_env !== "production"; var webpack = require('webpack'); var path = require('path'); module.exports = { context: path.join(__dirname, "src"), devtool: debug ? "inline-sourcemap" : null, entry: "./js/app.js", module: { loaders: [ { test: /\.jsx?$/, exclude: /(node_modules|bower_components)/, loader: 'babel-loader!preprocess-loader?+debug', // query: { // presets: ['react', 'es2015'], // plugins: ['react-html-attrs', 'transform-class-properties', 'transform-decorators-legacy'], // } }, { test: /\.css$/, loader: "style-loader!css-loader!sass-loader" } ] }, output: { path: __dirname + "/src/", f...
Read more