Re: Referencing uninitialized variables in plpgsql - Mailing list pgsql-general

From Tom Lane
Subject Re: Referencing uninitialized variables in plpgsql
Date
Msg-id 5349.1107713905@sss.pgh.pa.us
Whole thread Raw
In response to Re: Referencing uninitialized variables in plpgsql  ("Karl O. Pinc" <kop@meme.com>)
Responses Creating an index-type for LIKE '%value%'  (CG <cgg007@yahoo.com>)
List pgsql-general
"Karl O. Pinc" <kop@meme.com> writes:
> AFICT, the docs arn't clear when it comes to referencing unitialized
> array elements.  I assume you get NULL values here as well even
> though other array elements may have been given non-NULL values.

There is no such thing as an uninitialized array element.

Looking at array_ref, we do return a NULL if you try to fetch from a
position outside the current array subscript range.  But that's not
"uninitialized" in any normal sense of the word, it's more like
"nonexistent".  (I think you're right that it's undocumented behavior,
too.)

> Can I count on this?

Until someone makes an argument to change it ;-).

            regards, tom lane

pgsql-general by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Referencing uninitialized variables in plpgsql
Next
From: Christopher Browne
Date:
Subject: Re: Update command too slow