Skip site navigation (1) Skip section navigation (2)

Using unnest function on multi-dimensional array.

From: Nimesh Satam <nimesh(dot)zedo(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org, Nimesh Satam <nimesh(dot)satam(at)gmail(dot)com>
Subject: Using unnest function on multi-dimensional array.
Date: 2009-10-12 08:47:15
Message-ID: 965aa3ed0910120147k5b7d58f7ta02d44489e72ee64@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,

Can anybody highlight how to use unnest function from postgres 8.4 on
multi-dimensional array?

Below is the sample table structure:

Table "public.multi_array_test"
 Column  |   Type   | Modifiers
---------+----------+-----------
 id      | integer  |
 user_id | bigint[] |

Sample data:

  1 | {{3567559397,0},{3020933367,1},{2479094216,2},{3310282955,3}}

Regards,
Nimesh.

Responses

pgsql-performance by date

Next:From: Pavel StehuleDate: 2009-10-12 08:57:34
Subject: Re: Using unnest function on multi-dimensional array.
Previous:From: Brian KarlakDate: 2009-10-11 16:44:31
Subject: Re: table partitioning & max_locks_per_transaction

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group