Simple PostgreSQL 9.6 subquery

Cancelled Posted 5 years ago Paid on delivery
Cancelled Paid on delivery

I have an int type column on one table and a json type column on a different table.

I need a query that selects all rows from the int type column, separates them by a comma and UPDATES the json type column on a specific row with an array [] containing those comma-separated values.

PostgreSQL

Project ID: #17972833

About the project

11 proposals Remote project Active 5 years ago

11 freelancers are bidding on average $30 for this job

bhupen2606

Hi, i have good experience with SQL and PostgreSQL. If you let have a look at your table structure and query requirement, i should be able to provide required UPDATE statement. Thanks.

$25 USD in 1 day
(8 Reviews)
3.4
Darwin21015

Hello how are you, I am interested in your project, I have enough experience in postgres, with all kinds of simple queries and complex subqueries views, triggers, I have done work on this platform with postgres. you ca More

$40 USD in 10 days
(3 Reviews)
2.9
gabrieloba

Hi.. I work with data manipulation since 2012. Please send me your data file and I can show you the result and send you the script to update your database.

$20 USD in 1 day
(0 Reviews)
0.0
charlie02

Hi, I checked the requirements and I have experience in working with postgres databases. I can do Database design Write complex queries Store procedures Or anything related to database. Contact me for further discussi More

$25 USD in 1 day
(0 Reviews)
0.0
mielortiz

If I were to do this, I will use a select json_agg function and select the int rows. Create an alias for it. Insert it to the other table with the specific key for the row to be updated. I have done this a lot of times More

$25 USD in 1 day
(0 Reviews)
0.0
mnady

Hello, I used postgreSql on various projects before. I can build a demo for you that does what you want. please reply if you're interested Michael

$35 USD in 6 days
(0 Reviews)
0.0
nestor2105

I get the necessary expertise and the code that helps you to resolve this issue. So if you to decide choose my proposal, I will bring you the solution in few hours

$30 USD in 1 day
(0 Reviews)
0.0
AntonDonchev

I'd say you need to start with: SELECT array_to_string(array(SELECT <int-type-column> FROM <table>), ',') Do you want me to help? Best, Anton

$30 USD in 1 day
(0 Reviews)
0.0
jhz7

Hi, I know postgresql and that seems a simple task, implies to build a String with the values from INT column and then add it to JSON

$25 USD in 1 day
(0 Reviews)
0.0
mahidsekar

Working as a Database developer for past 10 Years. Skill set includes:Oracle, VB, Postgres, Sybase,etc Working in a leading IT company.

$25 USD in 1 day
(0 Reviews)
0.0