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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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