From: | Alexis Beuraud <alexis(at)siatel(dot)com> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Checking empty array |
Date: | 2007-10-30 10:07:45 |
Message-ID: | 20071030100749.71C879FB582@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
the web. I use the keyword isnull but that does not seem to work in all the
cases.
I would appreciate if someone could put this piece of information into the
Postgres documentation.
Here is what I do, in pseudo-code:
myarray varchar[];
myarray := '{}';
FOR ___ LOOP
IF (___) THEN
myarray := array_append(myarray, somestuff);
END IF;
END LOOP;
-- Is my array empty now?
IF (myarray isnull) THEN
__
END IF;
Regards,
Alexis Beuraud
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-10-30 10:32:11 | Re: Checking empty array |
Previous Message | vincent | 2007-10-30 09:08:03 | Re: Selecting K random rows - efficiently! |