Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

BUG #4956: Array Construct array() returning blank result



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.



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group