[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] How to get the MOST out of a database?
From:       <drevil () sidereal ! kz>
Date:       2000-12-30 7:18:26
[Download RAW message or body]


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

[prev in list] [next in list] [prev in thread] [next in thread]