finding last element of an index

From: Jim Mercer <jim(at)reptiles(dot)org>
To: pgsql-general(at)postgreSQL(dot)org
Subject: finding last element of an index
Date: 2000-01-27 09:31:17
Message-ID: 20000127043117.W20982@reptiles.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


if i have a table:

CREATE TABLE booga
(
name varchar(20),
addr varchar(20)
);
CREATE UNIQUE INDEX booga_idx ON booga (name);

is there a fast way to find the last entry in index booga_idx?

--
[ Jim Mercer jim(at)reptiles(dot)org +1 416 506-0654 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]

Browse pgsql-general by date

  From Date Subject
Next Message Nicolas Huillard 2000-01-27 11:39:00 Problem with search on INT4
Previous Message Holger Klawitter 2000-01-27 09:22:51 finding predecessor