From: | Jord Tanner <jord(at)indygecko(dot)com> |
---|---|
To: | Matthew Phillips <mphillips(at)timing(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: problem selecting rows with null value |
Date: | 2003-03-13 00:55:31 |
Message-ID: | 1047516930.24847.114.camel@gecko |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Use 'IS NULL' or 'IS NOT NULL' like this:
select * from pleah where bar IS NULL;
'=' does not work for null values.
On Wed, 2003-03-12 at 16:47, Matthew Phillips wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Jord Tanner <jord(at)indygecko(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Taral | 2003-03-13 01:55:00 | Re: problem selecting rows with null value |
Previous Message | Matthew Phillips | 2003-03-13 00:54:20 | Re: problem selecting rows with null value |