Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.6.0
    • Component/s: None
    • Labels:
      None

      Description

      The UNNEST built-in function converts an array into a set of rows. This is more than a built-in function, so should be considered an advanced project.

      For an example, see the following Postgres documentation: http://www.postgresql.org/docs/8.4/static/functions-array.html
      http://www.anicehumble.com/2011/07/postgresql-unnest-function-do-many.html
      http://tech.valgog.com/2010/05/merging-and-manipulating-arrays-in.html

      So the UNNEST is a way of converting an array to a flattened "table" which can then be filtered on, ordered, grouped, etc.

        Attachments

        1. PHOENIX-953-v1.patch
          43 kB
          Dumindu Buddhika
        2. PHOENIX-953-v2.patch
          24 kB
          Dumindu Buddhika
        3. PHOENIX-953-v3.patch
          38 kB
          Dumindu Buddhika
        4. PHOENIX-953-v4.patch
          33 kB
          Wei Xue

          Issue Links

            Activity

              People

              • Assignee:
                Dumindux Dumindu Buddhika
                Reporter:
                jamestaylor James R. Taylor
              • Votes:
                0 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: