Home > mailing lists

difference between not null and <> null - Mailing list pgsql-novice

From	sarlav kumar
Subject	difference between not null and <> null
Date	November 23, 2004 23:52:53
Msg-id	20041123205246.73040.qmail@web51308.mail.yahoo.com Whole thread Raw
Responses	Re: difference between not null and <> null (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-novice

Hi All,

Is there a difference between the usages of NOT NULL and <> NULL??

Do the following in anyway affect the use of index scan?

1) use of NOT NULL

2) use of now() instead of the actual date

Thanks,

Saranya

Do you Yahoo!?
Discover all that�s new in My Yahoo!

From: sarlav kumar
Date: 23 November 2004, 23:46:50
Subject: lock problem

From: Tom Lane
Date: 24 November 2004, 00:59:30
Subject: Re: difference between not null and <> null