Query Cost - Mailing list pgsql-general

From ShepherdHill DB Subscriptions
Subject Query Cost
Date
Msg-id 432DB49A.40904@shepherdhill.biz
Whole thread Raw
Responses Re: Query Cost
List pgsql-general
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

Thanks for your assistance.

Chris.

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: ltree and ordering - what index?
Next
From: Scott Ribe
Date:
Subject: Re: Asychronous database replication