Simple PostgreSQL 9.6 subquery

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 Más

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.

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 Más

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 Más

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.