Skip site navigation (1) Skip section navigation (2)

BUG #1252: Optimization of SELECT for NOT NULL case

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1252: Optimization of SELECT for NOT NULL case
Date: 2004-09-13 23:57:07
Message-ID: 20040913235707.DFCC25A1033@www.postgresql.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1252
Logged by:          Alexander Kirpa

Email address:      postgres(at)bilteks(dot)com

PostgreSQL version: 8.0 Beta

Operating system:   FreeBSD 5.2.1

Description:        Optimization of SELECT for NOT NULL case

Details: 

CREATE TABLE x (id int4 NOT NULL);
Populate table, for instance, 10M rows;
SELECT count(*) from x WHERE x IS NULL;
Optimizator should rewrite "x IS NULL" to simple "false"

Best regards,
 Alexander Kirpa


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-09-14 05:32:33
Subject: Re: Problem cocatenating String (||)
Previous:From: Tom LaneDate: 2004-09-13 21:04:08
Subject: Re: 8.0B2 psql \e

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group