Re: How to send multiple parameters to a pl/pgsql function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Sgarbossa Domenico <domenico(dot)sgarbossa(at)eniac(dot)it>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to send multiple parameters to a pl/pgsql function
Date: 2009-10-21 14:39:31
Message-ID: 27803.1256135971@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
>> I know that postgresql array implementation is not right complete and that if just
>> one element of array is NULL the basics array function (array_dims, array_upper, etc.) returns NULL.

> It's not true. Dimensions are stored independent to content.

I wonder if the OP is using an old version of Postgres. Since 8.2 we
can handle null elements of arrays, but 8.1 and older couldn't --- the
whole array went to null if you tried to include a null in it.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hfdabler 2009-10-21 15:20:21 Data migration tool certification
Previous Message Tom Lane 2009-10-21 13:42:23 Re: How to use Logical Operators in Fulltext Search?