From: | Michael Simms <grim(at)argh(dot)demon(dot)co(dot)uk> |
---|---|
To: | aaron(at)gtv(dot)ca (Aaron J(dot) Seigo) |
Cc: | hitesh(at)presys(dot)com (Hitesh Patel), pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] max() question |
Date: | 1999-09-14 18:43:14 |
Message-ID: | 199909141843.TAA10165@argh.demon.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>
> On Tue, 14 Sep 1999, you wrote:
> > I have a table with and email address and a datetime timestamp. What
> > would be the easiest way to select the 3 earliest timestamps (earliest
> > being furthest in the past from the current date)
>
> lots of ways =) though the first that comes to mind is the use of cursors.
> order by DATEFIELD asc and just grab the first three.. or if that don't work for
> ya (for whatever reason)... you could select the min(DATEFIELD), then select the
> min(DATEFIELD) where DATEFIELD > (that last select's return), then again for
> the third... this is convoluted, but if you are doing this over a network, a
> cursor may not be the easiest thing to implement, depending on what you are
> using. as for performance of this? i dunno. cursor would be best.
Hows about:
select * from table order by timestamp limit 3
That should do it
~Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 1999-09-15 01:52:43 | Re: [HACKERS] BUG with UNIQUE clause |
Previous Message | Aaron J. Seigo | 1999-09-14 18:22:15 | Re: [GENERAL] max() question |