| From: | Matthew Phillips <mphillips(at)timing(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | problem selecting rows with null value |
| Date: | 2003-03-13 00:47:30 |
| Message-ID: | 3E6FD522.8090803@timing.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am sure that I am doing something subtly wrong with my sql syntax
here. I thought that it was a timestamp null column issue, but it
doesn't work with int either. Is there a special way to denote the null
value in a situation like this that I don't know about?
tsc=# create table pleah(
tsc(# foo INT NOT NULL,
tsc(# bar timestamp DEFAULT NULL );
CREATE TABLE
tsc=# insert into pleah (foo) values (1);
INSERT 206475246 1
###ok here I would just like to select that row that I just inserted...
but no!
tsc=# select * from pleah where bar = NULL;
foo | bar
-----+-----
(0 rows)
tsc=# select * from pleah;
foo | bar
-----+-----
1 |
(1 row)
thanks muchly
matthew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua Moore-Oliva | 2003-03-13 00:49:53 | Re: problem selecting rows with null value |
| Previous Message | Taral | 2003-03-12 23:54:35 | No merge sort? |