On Jan 9, 2008 8:14 AM, cdecarlo <cdecarlo@xxxxxxxxx> wrote: > On Jan 8, 11:35 am, t...@xxxxxxxxxxxxx (Tom Lane) wrote: > > > > The rest of your message suggests that what you want is not that at all, > > but to set the other variable to an array that consists of one or moreelements > > from the original array. You need to be clearer in your own > > mind about which it is you're doing --- an array of one element is > > completely different from the element itself. > > > > If you use subscripts that include a colon (:), then the result is a > > sub-array and has to be assigned to a variable that's of the array > > type. If you don't use a colon then the subscripting operation produces > > a single value that's of the array element type, and has to be assigned > > to a variable of that type. You have to use the correct number of > > subscripts in either case, else you get a NULL, as you found out. > > > > regards, tom lane > > Tom, > > Maybe it's the combination of it being early in the day and that I'm > not much of a morning person lately, but your reply really pissed me > off. It came across as though you were 'helping' me from your > sanctimonious, holier-than-thou high horse, which, and I hope this > comes across as being clear in your mind, doesn't help. Wow, I totally didn't get that from his message... It was short and to the point. That's all I got. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings