Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-775

Support UPSERT of array values using ARRAY syntax

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Resolution: Fixed
    • 3.0-Release
    • 3.1.0, 4.1.0
    • None
    • None
    • 644

    Description

      Examples would include:

      UPSERT INTO my_table (first_name, last_name, my_array)
      VALUES ('John','Smith',ARRAY[25000,25000,27000,27000]);

      UPSERT INTO my_table (first_name, last_name, my_array)
      SELECT first_name,last_name, ARRAY[25000,25000,27000,27000]);

      Attachments

        Activity

          People

            ramkrishna Ramkrishna S. Vasudevan
            jamestaylor James R. Taylor
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: