8.1 beta2 RPMs

Hi,

PostgreSQL RPM Building Project (http://pgfoundry.org/projects/pgsqlrpms)
has built RPMs for Red Hat Enterprise Linux 3.0 and 4. More will come
later tomorrow:

http://developer.postgresql.org/~devrim/rpms/8.1/beta2/

We hope these RPMs will help more people to test this new great release of
PostgreSQL.

Please take care of the usual upgrade notes.

Regards,
--
Devrim GUNDUZ
Kivi Bilişim Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
>From pgsql-general-owner(at)postgresql(dot)org Sun Sep 18 19:01:55 2005
X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id E1BF3D91F3
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Sun, 18 Sep 2005 19:01:53 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 43438-07
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Sun, 18 Sep 2005 22:01:49 +0000 (GMT)
Received: from flake.decibel.org (flake.decibel.org [67.100.216.10])
by svr1.postgresql.org (Postfix) with ESMTP id AF419D9185
for <pgsql-general(at)postgresql(dot)org>; Sun, 18 Sep 2005 19:01:47 -0300 (ADT)
Received: by flake.decibel.org (Postfix, from userid 1001)
id CEE781524F; Sun, 18 Sep 2005 22:01:49 +0000 (GMT)
Date: Sun, 18 Sep 2005 17:01:49 -0500
From: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
To: ShepherdHill DB Subscriptions <db(dot)subscriptions(at)shepherdhill(dot)biz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Query Cost
Message-ID: <20050918220149(dot)GX7630(at)pervasive(dot)com>
References: <432DB49A(dot)40904(at)shepherdhill(dot)biz>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <432DB49A(dot)40904(at)shepherdhill(dot)biz>
X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386
X-Distributed: Join the Effort! http://www.distributed.net
User-Agent: Mutt/1.5.9i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006]
X-Spam-Level:
X-Archive-Number: 200509/717
X-Sequence-Number: 83732

On Sun, Sep 18, 2005 at 07:40:26PM +0100, ShepherdHill DB Subscriptions wrote:
> Hi,
>
> I have a table with this schema:
>
> CREATE TABLE billing.bill
> (
> sno serial NOT NULL,
> billno int4,
> det date NOT NULL,
> .
> .
> .
> CONSTRAINT bill_pkey PRIMARY KEY (sno)
> )
>
> I want to execute a query that will not return any record. Which of
> these queries is cheaper please?
>
> 1. Select * from billing.bill where 1=0
> 2. Select * from billing.bill where sno=0

Do an explain analyze and see. :)

1 will be faster because the optimizer can discard it right off the bat.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461