How to get the MOST out of a database? - Mailing list pgsql-general

From
Subject How to get the MOST out of a database?
Date
Msg-id 20001230071826.9498.qmail@mailhost.sidereal.kz
Whole thread Raw
List pgsql-general
In my application, I often want to select one row from a database
which is the most of something.  Perhaps I want the most recent row
corresponding to a certain user.  One way to do this is to

SELECT .... SORT BY date LIMIT 1

but I can't believe that this is an efficient way to do it.  Or is it?

Thanks,

Dr Evil


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Failed Statements within Transactions
Next
From: Lincoln Yeoh
Date:
Subject: Re: Re: Failed Statements within Transactions