Joe Conway <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> [ random griping ]
> Well, '{}' is a special case representing an empty array. Hmm ... good point ... it is not obvious whether that is an empty array (0x0) or a 1x1 array containing a single zero-length string. I guess if we want to make both these possibilities representable, we ought to stipulate that '{}' means the first and '{""}' means the second. > In my mind, '{{},{}}' clearly defines a two dimensional array, and > therefore needs elements, which in this case would have to be NULL (or > empty strings -- see below). Once we can deal with NULL elements, I'd > think '{{},{}}' ought to be accepted, and produce a 2d array with 2 NULL > elements. Note how this works in 7.4: Urgh ... that makes for a third case to support. How will you represent 0x0 vs 1x1 empty string vs 1x1 NULL? > I thought creation of empty strings was what we agreed the other day to > eliminate? I'm not sure that we had such an agreement, but in any case we've got to understand how to distinguish empty-string from NULL. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster