agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Bernhard Buettner <root@DL6RAI.MUC.DE>
To: postgres@postgres.Berkeley.EDU
Subject: Last 'n' records?
Date: Fri, 16 Sep 1994 22:50:08 +0200
Message-ID: <m0qlkES-0009C9C@dl6rai.muc.de> (raw)

Hello Postgres experts,

I am currently developing amateur radio software utilizig Postgres 
with a friend. The application is going to be used as an on-line 
database run under packet radio. The database contains data records 
which are being entered by many different users and the growth is about 
10,000 records/month.

A problem arises with the fact that very often a user wants to 
retrieve "the last 'n'" records of the database. Reading through
the manual, I could not find an operator to do this. At this time,
the query is realised as follows:

     retrieve portal P unique (data.all) sort by date using >
     fetch 5 in P

This will take the whole relation, sort it by date and then retrieve
the last 5 (0.01%). This cannot be the solution, but we can't find
any better. Any hints, ideas?

Greetings, 

Ben
-- 
[] Bernhard Buettner (Ben)
[]      Mail: Am Brunnen 18, 85551 Kirchheim, Germany
[]  Internet: root@dl6rai.muc.de
[]    Packet: DL6RAI @ DB0AAB.#BAY.DEU.EU

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: root@DL6RAI.MUC.DE
  Subject: Re: Last 'n' records?
  In-Reply-To: <m0qlkES-0009C9C@dl6rai.muc.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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