| From: | "Cristian Custodio" <crstian(at)terra(dot)com(dot)br> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Analytic Functions |
| Date: | 2003-02-11 13:44:39 |
| Message-ID: | 002601c2d1d3$bdf12f80$fb01a8c0@ttcristian |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Does anybody know tell me whether the PG have
analytic functions like the LEAD of Oracle?
I would like to create a SELECT where I can get
data of prior row like following example:
LAST_NAME HIRE_DATE Date of prior row
--------- --------- ---------
Raphaely 07-DEC-94 18-MAY-95
Khoo 18-MAY-95 24-JUL-97
Tobias 24-JUL-97 24-DEC-97
Baida 24-DEC-97 15-NOV-98
Himuro 15-NOV-98 10-AUG-99
Colmenares 10-AUG-99
On Oracle I can also to make this using ROWNUM.
Does anybody already need to make this
or have any soluction about it...
Thanks,
Cristian
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Grant | 2003-02-11 14:19:50 | Re: PostgreSQL x Oracle |
| Previous Message | Viacheslav N Tararin | 2003-02-11 13:41:24 | Rights for views. |