Re: Limitations of PostgreSQL

Scott Marlowe <smarlowe@g2switchworks.com> writes:
> I could see how it might be possible to make a two argument user defined
> function that took an argument like:

> select intvl(10,'20 30 40 50 60');

> so that the multiple arguments are really just a space or comma
> separated list fed to the function.  I wouldn't name it interval though.

Use an array:

    select intvl(10, array[20,30,40,50,60]);

I think you could even code this as a generic polymorphic function:

    create function intvl(anyelement, anyarray) returns anyelement ...

Anybody feel like filling it in with a standard binary search algorithm?

            regards, tom lane