Re: [BUGS] PG 7.4 BETA 3: Bug in NULL arrays updating

2003-09-23 Thread Joe Conway
Tom Lane wrote: Bertrand Petit <[EMAIL PROTECTED]> writes: When updating a NULL cell which is an array of something, setting an adressed member of a non existent array, the value of the cell is not changed. Assigning to a member of a NULL array has always yielded another NULL array. While

Re: [BUGS] PG 7.4 BETA 3: Bug in NULL arrays updating

2003-09-23 Thread Tom Lane
Bertrand Petit <[EMAIL PROTECTED]> writes: > When updating a NULL cell which is an array of something, > setting an adressed member of a non existent array, the value of the > cell is not changed. Assigning to a member of a NULL array has always yielded another NULL array. While I've never

[BUGS] PG 7.4 BETA 3: Bug in NULL arrays updating

2003-09-23 Thread Bertrand Petit
When updating a NULL cell which is an array of something, setting an adressed member of a non existent array, the value of the cell is not changed. > CREATE TABLE dummy (foo INT, bar VARCHAR[]); CREATE TABLE > INSERT INTO dummy (foo) VALUES (1); INSERT 43266442 1 > SELECT bar IS NULL AS i