Re: stored function - array parameter - how many element in array ? - Mailing list pgsql-general

From Volkan YAZICI
Subject Re: stored function - array parameter - how many element in array ?
Date
Msg-id 20060714062858.GA1585@alamut.tdm.local
Whole thread Raw
In response to Re: stored function - array parameter - how many element in array ?  (Claire McLister <mclister@zeesource.net>)
List pgsql-general
On Jul 13 08:28, Claire McLister wrote:
> Have you considered using a set instead? We had a similar need and
> were using an array as a parameter. That turned out to be taking too
> long. Recently we have changed it to a set and it seems to work
> faster, although I must admit I haven't timed it yet.

Did you experience same results when you use an indexable (integer)
array type supplied by intarray contrib module? Furthermore, there're
lots of useful procedures and operators which supplies any kind of
functionality you'll ever need with arrays. Also it's obviouse that
there's no need to tell that these libraries are written in C with quite
optimized algorithms.


Regards.

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Timestamp vs timestamptz
Next
From: Florian Weimer
Date:
Subject: Re: Timestamp vs timestamptz