pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: [SQL] OID & indexes.
4+ messages / 4 participants
[nested] [flat]

* OID & indexes.
@ 1999-09-21 21:56 raptor <raptor@unacs.bg>
  1999-09-21 15:10 ` Re: [SQL] OID & indexes. Tom Lane <tgl@sss.pgh.pa.us>
  1999-09-21 15:24 ` Re: [SQL] OID & indexes. Bruce Momjian <maillist@candle.pha.pa.us>
  1999-09-22 12:30 ` Re: [SQL] OID & indexes. José Soares <jose@sferacarta.com>
  0 siblings, 3 replies; 4+ messages in thread

From: raptor @ 1999-09-21 21:56 UTC (permalink / raw)
  To: pgsql-sql

hi,

Is the OID fileld indexed and if not can I create index on it.

Thanx
=====
iVAN
raptor@unacs.bg
=====




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] OID & indexes.
  1999-09-21 21:56 OID & indexes. raptor <raptor@unacs.bg>
@ 1999-09-21 15:10 ` Tom Lane <tgl@sss.pgh.pa.us>
  2 siblings, 0 replies; 4+ messages in thread

From: Tom Lane @ 1999-09-21 15:10 UTC (permalink / raw)
  To: raptor <raptor@unacs.bg>; +Cc: pgsql-sql

raptor <raptor@unacs.bg> writes:
> Is the OID fileld indexed and if not can I create index on it.

No, and yes.  OID is just like any regular column as far as
indexing is concerned.  You should make an index on it if you
plan to do lots of 'WHERE oid = something' queries.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] OID & indexes.
  1999-09-21 21:56 OID & indexes. raptor <raptor@unacs.bg>
@ 1999-09-21 15:24 ` Bruce Momjian <maillist@candle.pha.pa.us>
  2 siblings, 0 replies; 4+ messages in thread

From: Bruce Momjian @ 1999-09-21 15:24 UTC (permalink / raw)
  To: raptor <raptor@unacs.bg>; +Cc: pgsql-sql

> 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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] OID & indexes.
  1999-09-21 21:56 OID & indexes. raptor <raptor@unacs.bg>
@ 1999-09-22 12:30 ` José Soares <jose@sferacarta.com>
  2 siblings, 0 replies; 4+ messages in thread

From: José Soares @ 1999-09-22 12:30 UTC (permalink / raw)
  To: raptor <raptor@unacs.bg>; +Cc: pgsql-sql



raptor ha scritto:

> hi,
>
> Is the OID fileld indexed and if not can I create index on it.
>

The OID field is not indexed by default but you can create an index on
it as:
create index idx_name on  table_name (oid);

José





^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~1999-09-22 12:30 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-21 21:56 OID & indexes. raptor <raptor@unacs.bg>
1999-09-21 15:10 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-09-21 15:24 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-09-22 12:30 ` José Soares <jose@sferacarta.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox