Re: obtaining ARRAY position for a given match

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: obtaining ARRAY position for a given match
Date: 2009-11-19 18:05:19
Message-ID: 20091119180519.GU5407@samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 19, 2009 at 12:43:38PM -0500, Merlin Moncure wrote:
> we could use a version
> of unnest that works like that (returns idx, elem)? It would be a
> small efficiency win over generate_series based approaches.

What would "idx" look like for multidimensional arrays? I think PG
needs a sensible way of dealing with these before you attempt to modify
unnest.

--
Sam http://samason.me.uk/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2009-11-19 18:33:07 Re: obtaining ARRAY position for a given match
Previous Message Raimon Fernandez 2009-11-19 18:01:53 Re: Encoding using the Frontend/Backend Protocol TCP/IP