SEO
vBulletin Search Engine Optimization
| |||||||
![Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {}](http://unixadmintalk.com/iconimages/f41/re-sql-array-returning-null-instead-array-resp_ltr.gif)
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-11-2008, 04:03 AM
| ||||
| ||||
 Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {} Dnia 24-05-2005, wto o godzinie 00:06 -0400, Tom Lane napisał(a): > Joe Conway <mail@joeconway.com> writes: > > Markus Bertheau wrote: > >> why does SELECT ARRAY(SELECT 1 WHERE FALSE) return NULL instead of > >> ARRAY[] resp. '{}'? > > > Why would you expect an empty array instead of a NULL? > > I think he's got a good point, actually. We document the ARRAY-with- > parens-around-a-SELECT syntax as > > The resulting one-dimensional array will have an element for > each row in the subquery result, with an element type matching > that of the subquery's output column. > > To me, that implies that a subquery result of no rows generates a > one-dimensional array of no elements, not a null array. > > The point Markus is complaining about seems like it should > be easily fixable. Great. Does this belong on the TODO? -- Markus Bertheau <twanger@bluetwanger.de> -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQBCksTX2RUnMPztcykRAkkZAJ465rp+1epDP0ocGXF6hb nxah+fywCfYZR3 BcwfnfGtQFqo+PMFndZSSYw= =yUQY -----END PGP SIGNATURE-----      |
Linear Mode
