find position of an special entry in a select-result - Mailing list pgsql-general

From Peter Pilsl
Subject find position of an special entry in a select-result
Date
Msg-id 20010424015209.A93215@i3.atat.at
Whole thread Raw
List pgsql-general
I perform a complex select-operation on a database with 10.000 entries
and with various Where-clauses I get 200 results. Now I want to get
the position of one special entry (identified by its OID) in this
selection.

Background: The user can fully customize a query in an online-database
(sort by, search, entries per page ...). When he adds a new entry to
that database the application should automatically show exact the page
where the new entry is displayed.

thnx,
peter



--
mag. peter pilsl

phone: +43 676 3574035
fax  : +43 676 3546512
email: pilsl@goldfisch.at
sms  : pilsl@max.mail.at

pgp-key available

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump failure: "handler procedure for language plpgsql not foun d"
Next
From: Michelle Murrain
Date:
Subject: Re: installing DBD::Pg without installing postgres