Just a Question

From: "Bosco Ng" <boscoklng(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Just a Question
Date: 2002-04-16 13:34:10
Message-ID: F87wVN7miR9Odutox7n00005d99@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-04-16 13:47:43 Re: Firebird 1.0 released
Previous Message Gavin Sherry 2002-04-16 13:26:35 Re: Testers needed ...