Alexis Beuraud wrote:
> What is the correct way to check whether an array is empty?
>
> Here is what I do, in pseudo-code:
>
> -- Is my array empty now?
> IF (myarray isnull) THEN
Try this:
IF array_lower(myarray, 1) IS NULL THEN ... END IF
Yours,
Laurenz Albe
---(end
2007/10/30, Alexis Beuraud <[EMAIL PROTECTED]>:
> Dear all,
>
> What is the correct way to check whether an array is empty?
> I have an array which I initialize with '{}' and then do som array_append
> under some circonstances. I would like to know whether the array is empty at
> the end of the fun
Alexis Beuraud wrote:
Dear all,
What is the correct way to check whether an array is empty?
-- Is my array empty now?
IF (myarray isnull) THEN
An empty array isn't null (unknown), it's empty.
Try enquiring about it's size:
SELECT array_dims('{}'::integer[]) is null;
?column?
--
t
Dear all,
What is the correct way to check whether an array is empty?
I have an array which I initialize with '{}' and then do som array_append
under some circonstances. I would like to know whether the array is empty at
the end of the function. I have not found the answer in the help page nor on
