Re: [BUGS] NULL in arrays

2004-01-15 Thread Dennis Bjorklund
On Thu, 15 Jan 2004, Joe Conway wrote: > I agree, and see Tom does too in a nearby post. Do you want to propose > some wording, or just leave it up to me? You do it, and I'll just complain later if I don't like it :-) I still think it's a strange behaviour, but as long as it's documented it's

Re: [BUGS] NULL in arrays

2004-01-15 Thread Joe Conway
Dennis Bjorklund wrote: On Thu, 15 Jan 2004, Joe Conway wrote: Additionally, this behavior was discussed during the 7.4 development and beta cycles on at least a couple occassions -- that would have been the time to complain, not now. Well, I will complain whenever I see something I don't like :-

Re: [BUGS] NULL in arrays

2004-01-15 Thread Tom Lane
Dennis Bjorklund <[EMAIL PROTECTED]> writes: > In the documentation I got the impression that NULL values inside an array > was not allowed. Now I know that you are allowed to form such an > expression and that it evaluates to the NULL array. The documentation > should be fixed then (or maybe it is

Re: [BUGS] NULL in arrays

2004-01-15 Thread Dennis Bjorklund
On Thu, 15 Jan 2004, Joe Conway wrote: > Additionally, this behavior was discussed during the 7.4 development and > beta cycles on at least a couple occassions -- that would have been the > time to complain, not now. Well, I will complain whenever I see something I don't like :-) Just because

Re: [BUGS] NULL in arrays

2004-01-15 Thread Joe Conway
Tom Lane wrote: As we used to say at HP, this is not a bug, it's a definition disagreement. You need to give a coherent argument why we should change, not just claim it's wrong. Additionally, this behavior was discussed during the 7.4 development and beta cycles on at least a couple occassions --

Re: [BUGS] NULL in arrays

2004-01-15 Thread Dennis Bjorklund
On Thu, 15 Jan 2004, Tom Lane wrote: > > dennis=# INSERT INTO foo VALUES (ARRAY[2,NULL]); > > INSERT 25353 1 > > > That last insert contains a NULL value which are not allowed in arrays and > > yet a insert is performed. The table contains a NULL value afterwards > > (and no array). > > As we u

Re: [BUGS] NULL in arrays

2004-01-15 Thread Tom Lane
Dennis Bjorklund <[EMAIL PROTECTED]> writes: > dennis=# INSERT INTO foo VALUES (ARRAY[2,NULL]); > INSERT 25353 1 > That last insert contains a NULL value which are not allowed in arrays and > yet a insert is performed. The table contains a NULL value afterwards > (and no array). As we used to sa

Re: [BUGS] NULL in arrays

2004-01-15 Thread Dennis Bjorklund
On Thu, 15 Jan 2004, Dennis Bjorklund wrote: > A person (cross) in the irc channel Actually, he calls himself crass which is the only name I have :-) Not very important, but I like things to be correct (when I can). -- /Dennis Björklund ---(end of broadcast)--