| From: | Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)PostgreSQL(dot)org |
| Subject: | Re: Numbering rows |
| Date: | 2008-10-16 09:00:37 |
| Message-ID: | gd6vrm$np1$1@pye-srv-01.telemetry.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
David Rowley wrote:
> It's not 100% certain that it will be possible for 8.4, probably though.
>
> select row_number() over (order by employeeid) as nrow,* from employee order
> by employeeid
That makes sense, thanks. So extracting rate-of-change etc. would be a
join on two subselects followed by a bit of maths, that's likely to be a
big incentive for an upgrade when it comes out.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rafał Ziółkowski | 2008-10-16 11:16:12 | PQescapestringConn not found in libpq.dll |
| Previous Message | Tomasz Ostrowski | 2008-10-16 08:54:47 | Re: Drupal and PostgreSQL - performance issues? |