array surprising behavior

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: array surprising behavior
Date: 2004-02-04 12:08:38
Message-ID: 20040204120838.GA10446@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I think this is most surprising behavior -- shouldn't the UPDATE raise
an error?

alvherre=# create table foo (a int[]);
CREATE TABLE
alvherre=# insert into foo values (null);
INSERT 33649 1
alvherre=# update foo set a[3] = '42';
UPDATE 1
alvherre=# select a, a is null from foo;
a | ?column?
---+----------
| t
(1 fila)
alvherre=# select version();
version
-----------------------------------------------------------------------------------------------------------
PostgreSQL 7.5devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.1 (Mandrake Linux 9.2 3.3.1-2mdk)
(1 fila)

(This is CVS tip as of a couple weeks ago)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El destino baraja y nosotros jugamos" (A. Schopenhauer)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Browne 2004-02-04 13:10:58 Re: Recursive queries?
Previous Message Andrew Rawnsley 2004-02-04 11:57:30 Re: Recursive queries?