finding last element of an index - Mailing list pgsql-general

From Jim Mercer
Subject finding last element of an index
Date
Msg-id 20000127043117.W20982@reptiles.org
Whole thread Raw
List 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@reptiles.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.  ]

pgsql-general by date:

Previous
From: Holger Klawitter
Date:
Subject: finding predecessor
Next
From: Mark Jewiss
Date:
Subject: Re: [GENERAL] reverse sorting