From: | Stephen Tahmosh <stahmosh(at)shieldsrx(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | "emilu(at)encs(dot)concordia(dot)ca" <emilu(at)encs(dot)concordia(dot)ca>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: query based on row number for psql8.3 |
Date: | 2016-03-23 18:15:56 |
Message-ID: | DM2PR0701MB1295C58B0022C8FD8EB3BB56C4810@DM2PR0701MB1295.namprd07.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
Excuse my ignorance.
What is a “top-post”?
Thanks,
STeve
From: David G. Johnston [mailto:david(dot)g(dot)johnston(at)gmail(dot)com]
Sent: Wednesday, March 23, 2016 2:15 PM
To: Stephen Tahmosh <stahmosh(at)shieldsrx(dot)com>
Cc: emilu(at)encs(dot)concordia(dot)ca; pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] query based on row number for psql8.3
On Wednesday, March 23, 2016, Stephen Tahmosh <stahmosh(at)shieldsrx(dot)com<mailto:stahmosh(at)shieldsrx(dot)com>> wrote:
Row_number is an "analytic" function,
Row_number is a window function and those did not exist back in 8.3...
And please don't top-post.
Thanks!
David J.
THIS MESSAGE (AND ALL ATTACHMENTS) IS INTENDED FOR THE USE OF THE PERSON OR ENTITY TO WHOM IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If you are not the intended recipient, your use of this message for any purpose is strictly prohibited. If you have received this communication in error, please delete the message without making any copies and notify the sender so that we may correct our records. Thank you.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-03-23 18:17:50 | Re: query based on row number for psql8.3 |
Previous Message | David G. Johnston | 2016-03-23 18:14:31 | Re: query based on row number for psql8.3 |