Re: Nested query performance issue - Mailing list pgsql-performance

From Glenn Maynard
Subject Re: Nested query performance issue
Date
Msg-id d18085b50904091642k2c610f53gbdef921319073683@mail.gmail.com
Whole thread Raw
In response to Re: Nested query performance issue  (Віталій Тимчишин <tivv00@gmail.com>)
List pgsql-performance
2009/4/9 Віталій Тимчишин <tivv00@gmail.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

pgsql-performance by date:

Previous
From: Glenn Maynard
Date:
Subject: Re: Nested query performance issue
Next
From: Greg Smith
Date:
Subject: Re: Nested query performance issue