6.5.1 -vs- null values for an int8

From: Robert Forsman <thoth(at)nile(dot)purplefrog(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: 6.5.1 -vs- null values for an int8
Date: 1999-11-15 19:10:34
Message-ID: 199911151910.OAA01316@nile.purplefrog.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Any clue why Postgresql version 6.5.1 can't handle null values for int8 in
a WHERE clause?

incanta=> create table t(v int8);
CREATE
incanta=> insert into t(v) values(0);
INSERT 101737 1
incanta=> insert into t(v) values(1);
INSERT 101738 1
incanta=> insert into t(v) values(-1);
INSERT 101739 1
incanta=> select * from t where v>=0;
v
-
0
1
(2 rows)

incanta=> insert into t(v) values (null);
INSERT 101740 1
incanta=> select * from t;
v
--
0
1
-1

(4 rows)

incanta=> select * from t where v>=0;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is impossible. Terminating.

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1999-11-15 19:26:56 Re: [HACKERS] Looks like hell, but ...
Previous Message Brian Hirt 1999-11-15 18:14:26 Re: [HACKERS] Looks like hell, but ...