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
On Oracle I can also to make this using ROWNUM.
Does anybody already need to make this
or have any soluction about it...
pgsql-general by date
|Next:||From: Tony Grant||Date: 2003-02-11 14:19:50|
|Subject: Re: PostgreSQL x Oracle|
|Previous:||From: Viacheslav N Tararin||Date: 2003-02-11 13:41:24|
|Subject: Rights for views.|