Postgres Pro
Downloads
Home   >   mailing lists

Re: obtaining ARRAY position for a given match - Mailing list pgsql-general

From Sam Mason
Subject Re: obtaining ARRAY position for a given match
Date
Msg-id 20091119180519.GU5407@samason.me.uk
Whole thread Raw
In response to Re: obtaining ARRAY position for a given match  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: Raimon Fernandez
Date:
Subject: Re: Encoding using the Frontend/Backend Protocol TCP/IP
Next
From: Pavel Stehule
Date:
Subject: Re: obtaining ARRAY position for a given match