From: | "Niranjan Pandit" <niranjan81(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4956: Array Construct array() returning blank result |
Date: | 2009-07-31 03:02:57 |
Message-ID: | 200907310302.n6V32vP8034510@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4956
Logged by: Niranjan Pandit
Email address: niranjan81(at)gmail(dot)com
PostgreSQL version: 8.4
Operating system: Windows Vista Ultimate
Description: Array Construct array() returning blank result
Details:
Hi,
I simply wanted to accumulate result of a subquery in to an array, so I did
select array(select userid from user where <some condition>);
Only when the condition gets evaluated to true with at least 2 columns with
varying values the array gets constructed, in all other cases what we get is
a complete blank output. the label of the result is as usual as ?column? but
there is absolutely nothing in the cell below the label.
I am sorry if I am repeating something already known to mankind :-) but
after a lot search I could not get anything on it on the net.
Thanks in advance.
Best Wishes.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2009-07-31 03:15:55 | Re: Fwd: BUG #4953: Crash with xml functions |
Previous Message | Dan Boeriu | 2009-07-30 22:11:39 | Re: BUG #4945: Parallel update(s) gone wild |