From: | Rachit Siamwalla <rachit(at)ensim(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Does the oid column have an implicit index on it? |
Date: | 2001-08-25 04:01:39 |
Message-ID: | 9AC41B8C4781464695BB013F106FCA3102900BDA@nasdaq.ms.ensim.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This may sound like a stupid question, and i apologize if it is, but I
couldn't find the answer in any documentation.
Every table has a implicit column oid. Does this column have an index on it?
I assume not, and I am putting an index on it anyway.
The real problem is that I have a table like the following:
create table foo (
time timestamp DEFAULT CURRENT_TIMESTAMP,
...
)
I insert an row, and I want to get the timestamp of that row. So i do a
select on oid. I want an index. Does one already exist?
-rchit
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-08-25 04:33:29 | MD5 for ODBC |
Previous Message | Dominic J. Eidson | 2001-08-25 01:46:07 | Re: [PATCHES] Patch to include PAM support... |