| From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
|---|---|
| To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Select values by interval |
| Date: | 2015-11-23 17:31:09 |
| Message-ID: | 20151123173109.GA8959@tux |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> Unproven but whenever you have a query of this form (row_number = 1) you
> should consider/test whether using DISTINCT ON with an appropriate ORDER BY
> clause gives you the answer faster and/or more clearly.
Nice hint.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sribeiro | 2015-11-23 19:38:02 | ERROR while creating new user - could not open relation mapping file global/pg_filenode.map |
| Previous Message | David G. Johnston | 2015-11-23 17:25:05 | Re: Select values by interval |