Just a Question - Mailing list pgsql-hackers

From Bosco Ng
Subject Just a Question
Date
Msg-id F87wVN7miR9Odutox7n00005d99@hotmail.com
Whole thread Raw
List pgsql-hackers
Sorry, just a question, maybe I should ask somewhere else.

Is there any difference (like cost, efficiency, execution paths...) between
this sql:

select b
from a
where b is not null

and this sql:

select b
from a
where not b is null


Just curious.

Thanks for your answer

Bosco



_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: multibyte support by default
Next
From: Louis-David Mitterrand
Date:
Subject: Re: Index Scans become Seq Scans after VACUUM ANALYSE