Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA32019 for ; Tue, 21 Sep 1999 11:24:50 -0400 (EDT) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id LAA11589; Tue, 21 Sep 1999 11:24:35 -0400 (EDT) From: Bruce Momjian Message-Id: <199909211524.LAA11589@candle.pha.pa.us> Subject: Re: [SQL] OID & indexes. In-Reply-To: <37E7FF29.1BB059BC@unacs.bg> from raptor at "Sep 21, 1999 05:56:58 pm" To: raptor Date: Tue, 21 Sep 1999 11:24:35 -0400 (EDT) CC: "'pgsql-sql@postgresql.org'" X-Mailer: ELM [version 2.4ME+ PL56 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > hi, > > Is the OID fileld indexed and if not can I create index on it. It is not indexed by default. You have to create an index on it. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026