Re: obtaining ARRAY position for a given match

From: Scott Bailey <artacus(at)comcast(dot)net>
To:
Cc: Postgresql Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: obtaining ARRAY position for a given match
Date: 2009-11-19 17:15:35
Message-ID: 4B057D37.6010807@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> FROM generate_series(array_lover($1,1),array_upper($1,1)) g(i)

Pavel,

Don't get me wrong, I enjoy coding, but I think you've taken it too far
here ;)

Yes, definitely more effective for large arrays. Thanks. Would probably
be a good snippet for the wiki.

Scott

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-11-19 17:43:38 Re: obtaining ARRAY position for a given match
Previous Message Raimon Fernandez 2009-11-19 17:13:42 Re: Encoding using the Frontend/Backend Protocol TCP/IP