>Gerald Clark wrote:
> >
> > You need to read up on what NULL means.
> > There is nothing that = NULL.
> >
> > try:
> > WHERE last_visit IS NULL
>
>I _do_ understand what NULL means. Watch this: (with Postgres):
>
>mark=> insert into t (c2) values (NULL);
>INSERT 2419008 1
>mark=> select * f
Mark Stosberg <[EMAIL PROTECTED]> writes:
> Tonu, thanks for the explanation. I still prefer the way Postgres
> handles it:
>
> Mark=> select * from t where c2 = null;
> c1 | c2
> ---+
> 1 |
> (1 row)
Postgres is incorrect in doing this. At least, it's way non-standard.
NULL is *NOT* a v
At 3:45 PM -0500 6/5/01, Mark Stosberg wrote:
>Jeremy Zawodny wrote:
>>
>> On Tue, Jun 05, 2001 at 02:18:15PM -0500, Mark Stosberg wrote:
>> >
>> > However, if I ask for the rows where last_visit = NULL, it says there are
>> > not any! :
>> > mysql> select user_id,screen_name,password,last_vi
Tonu Samuel wrote:
>
> On Tue, 5 Jun 2001, Mark Stosberg wrote:
>
> > > > second_to_last_visit from users where last_visit = NULL;
> > >
> > > What if you use "last_visit IS NULL"?
> >
> > Thanks, this works. I still think MySQL behaved poorly by not either:
> > a), accepting my syntax, or B.)
On Tue, 5 Jun 2001, Mark Stosberg wrote:
> > > second_to_last_visit from users where last_visit = NULL;
> >
> > What if you use "last_visit IS NULL"?
>
> Thanks, this works. I still think MySQL behaved poorly by not either:
> a), accepting my syntax, or B.) throwing an error that the syntax wa
query should be:
select user_id,screen_name,password,last_visit,
second_to_last_visit from users where last_visit IS NULL;
Just an sql-ism
Mike
-Original Message-
From: Mark Stosberg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 2:18 PM
To: [EMAIL PROTECTED]
Subject: Nulls a
Gerald Clark wrote:
>
> You need to read up on what NULL means.
> There is nothing that = NULL.
>
> try:
> WHERE last_visit IS NULL
I _do_ understand what NULL means. Watch this: (with Postgres):
mark=> insert into t (c2) values (NULL);
INSERT 2419008 1
mark=> select * from t where c2 = NULL;
You need to read up on what NULL means.
There is nothing that = NULL.
try:
WHERE last_visit IS NULL
Mark Stosberg wrote:
> I'm using MySQL 3.23.32 and having trouble selecting values where a
> column is null. Any help is appreciated. An example is below:
>
> I need to get the rows where the l
Jeremy Zawodny wrote:
>
> On Tue, Jun 05, 2001 at 02:18:15PM -0500, Mark Stosberg wrote:
> >
> > However, if I ask for the rows where last_visit = NULL, it says there are
> > not any! :
> > mysql> select user_id,screen_name,password,last_visit,
> > second_to_last_visit from users where last_visi
On Tue, Jun 05, 2001 at 02:18:15PM -0500, Mark Stosberg wrote:
>
> However, if I ask for the rows where last_visit = NULL, it says there are
> not any! :
> mysql> select user_id,screen_name,password,last_visit,
> second_to_last_visit from users where last_visit = NULL;
What if you use "last_vis
Mark Stosberg wrote:
>
> I'm using MySQL 3.23.32 and having trouble selecting values where a
> column is null. Any help is appreciated. An example is below:
>
> I need to get the rows where the last_visit column in the users table is
> NULL.
> I can see that there are some with this select state
11 matches
Mail list logo
