Re: [PERFORM] Using unnest function on multi-dimensional array.

Hello 2009/10/12 Nimesh Satam : > 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  |

[PERFORM] Using unnest function on multi-dimensional array.

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