Re: Nested query performance issue

From: Glenn Maynard <glennfmaynard(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Nested query performance issue
Date: 2009-04-09 23:42:41
Message-ID: d18085b50904091642k2c610f53gbdef921319073683@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2009/4/9 Віталій Тимчишин <tivv00(at)gmail(dot)com>:
> create or replace function explode_array(in_array anyarray) returns setof
> anyelement as
> $$
>     select ($1)[s] from generate_series(1,array_upper($1, 1)) as s;
> $$
> language sql immutable;

I tried using an ARRAY like this, but didn't quite figure out the
explode_array piece.

--
Glenn Maynard

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2009-04-09 23:59:41 Re: Nested query performance issue
Previous Message Glenn Maynard 2009-04-09 23:42:18 Re: Nested query performance issue