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
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
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