Postgres Pro
Downloads
Home   >   mailing lists

select * from table where oid = number; - Mailing list pgsql-general

From Taral
Subject select * from table where oid = number;
Date
Msg-id 001001bdf2f4$92dad980$3b291f0a@taral
Whole thread Raw
Responses Re: [GENERAL] select * from table where oid = number;
List pgsql-general
Tree view 
Is there a reason why this occurs?

table=> explain select * from data where oid = 18522;
NOTICE:  QUERY PLAN:

Seq Scan on data  (cost=0.00 size=0 width=120)

EXPLAIN

I would have expected an index scan or something.

TAral

pgsql-general by date:

Previous
From: Evan Howarth
Date:
Subject: Re: [GENERAL] SELECT Date
Next
From: La Mancha de la Calabaza que Ladra
Date:
Subject: ...