Simple PostgreSQL 9.6 subquery
$10-30 USD
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.
Project ID: #17972833
About the project
11 freelancers are bidding on average $30 for this job
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.
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
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.
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
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
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
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
Working as a Database developer for past 10 Years. Skill set includes:Oracle, VB, Postgres, Sybase,etc Working in a leading IT company.