В Пнд, 06/06/2005 в 10:44 -0400, Tom Lane пишет: > Markus Bertheau =?UTF-8?Q?=E2=98=AD?= <[EMAIL PROTECTED]> writes: > > By analogy, array_upper('{}'::TEXT[], 1) should return 0 instead of > > NULL. > > No, that doesn't follow ... we've traditionally considered '{}' to > denote a zero-dimensional array.
But array_upper(ARRAY(SELECT 1 WHERE FALSE), 1) should return 0, and array_upper(ARRAY[], 1), when the ARRAY[] syntax is supported, should return 0. Do I get that right? Markus -- Markus Bertheau ☭ <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org