Re: stored function - array parameter - how many element in array ?

From: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>
To: Claire McLister <mclister(at)zeesource(dot)net>
Cc: Özgür Tuğrul <ozgur(dot)tugrul(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: stored function - array parameter - how many element in array ?
Date: 2006-07-14 06:28:58
Message-ID: 20060714062858.GA1585@alamut.tdm.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Florian Weimer 2006-07-14 07:27:23 Re: Timestamp vs timestamptz
Previous Message Michael Glaesemann 2006-07-14 05:11:18 Re: Timestamp vs timestamptz